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"));
}
