I'M WRITING A CODE TO AUTOMATIC GENERATE STAFF NUMBER. AM STOCK PLEASE HELP ME OUT...
// FORMAT OF THE STAFF NUMBER (FMCEB/HR/1043) THAT IS THE LAST NUMBER IN MY DATABASE
// READING FROM DATABASE
PLEASE HELP A BROTHER OUT!!!
// FORMAT OF THE STAFF NUMBER (FMCEB/HR/1043) THAT IS THE LAST NUMBER IN MY DATABASE
// READING FROM DATABASE
var a = (from m in db.Staffs orderby m.StaffId descending select m).Take(1).SingleOrDefault(); if (a != null) { string stid = a.StaffNo.ToString(); if (stid.Length == 9) { string output = (stid.Substring(9, 3)); int num = Convert.ToInt32(output) + 1; newstaffno = "FMCEB/HR/" + num.ToString(); } } else { int id = 1; string year = DateTime.Now.Year.ToString(); newstaffno = "FMCEB/HR/" + year + id.ToString(); }
PLEASE HELP A BROTHER OUT!!!
Last edited by a moderator: