public string Generate_ID(string tablename) { string ret = null; string val1 = null; string val2 = null; Generate_ID gen = new Generate_ID(); Generate_IDEnt genE = new Generate_IDEnt(); switch (tablename) { case "Requisition": { gen = (from g in ContextDB.Generate_ID where g.Table_Name == tablename select g).First(); if (gen.Seg1 < 99) { val1 = (gen.Seg1 + 1).ToString(); } else { val2 = (gen.Last_ID + 1).ToString(); gen.Last_ID = 10; } //val1 = (gen.Last_ID + 1).ToString(); //val2 = (gen.Seg1 + 1).ToString(); ret = val2 + "/" + val1; //gen.Last_ID = gen.Last_ID + 1; //gen.Seg2 = gen.Seg2 + 1; //genE.updateGenerateID(gen); break; } case "Purchase_Order": { gen = (from g in ContextDB.Generate_ID where g.Table_Name == tablename select g).First(); ret = (gen.Last_ID + 1).ToString(); //gen.Last_ID = gen.Last_ID + 1; //genE.updateGenerateID(gen); break; } case "StockCard_Detail": { gen = (from g in ContextDB.Generate_ID where g.Table_Name == tablename select g).First(); ret = "TND" + (gen.Last_ID + 1).ToString(); break; } case "Disbursement": { gen = (from g in ContextDB.Generate_ID where g.Table_Name == tablename select g).First(); ret = (gen.Last_ID + 1).ToString(); break; } case "Adjustment_Voucher": { gen = (from g in ContextDB.Generate_ID where g.Table_Name == tablename select g).First(); if (gen.Last_ID < 99) { val1 = (gen.Last_ID + 1).ToString(); } else { val2 = (gen.Seg1 + 1).ToString(); gen.Last_ID = 10; } break; } default : return "xxx"; } return ret; }
public bool Increament_GenID(int id) { try { Generate_IDEnt gEnt = new Generate_IDEnt(); Generate_ID gid = new Generate_ID(); gid.ID = id; gid.Last_ID = (from g in ContextDB.Generate_ID where g.ID == id select g.Last_ID).SingleOrDefault() + 1; gEnt.updateGenerateID(gid); return true; } catch (Exception e) { return false; } }