public static object GetDesignationTypeID(string DesignCode) { database db = new database(); db.AddParameter("@DesignationCode", DesignCode); db.AddParameter("@QryType", "G"); return(db.GetDataValue("DesigCode")); }
public static void Delete(string id) { database db = new database(); db.AddParameter("@DesigId", id); db.AddParameter("@QryType", "D"); db.ExecuteSP("DesigProc"); }
public static void Save(Desig st, string QryType) { database db = new database(); db.AddParameter("@DesigId", st.DesigId); db.AddParameter("@DesigNm", st.DesigNm); db.AddParameter("@DesigTypeID", st.DesigTypeID); db.AddParameter("@QryType", QryType); db.ExecuteSP("DesigProc"); }
public static DataTable GetDesignationType() { database db = new database(); db.AddParameter("@QryType", "S"); return(db.GetDataTable("DesigCode")); }
public static string GetMaxStateId() { database db = new database(); db.AddParameter("@QryType", "M"); return(db.GetMaxId("DesigProc").ToString()); }
public static DataTable GetStates() { database db = new database(); db.AddParameter("@QryType", "S"); return(db.GetDataTable("DesigProc")); }