internal DataTable LoadBranch(OfflineUtilityModel ObjOfflineUtilityModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPMasters"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@DataInd", ObjOfflineUtilityModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOfflineUtilityModel.OrgID); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtOfflineUtility = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtOfflineUtility); dtOfflineUtility.TableName = "success"; } catch (Exception) { dtOfflineUtility = new DataTable(); dtOfflineUtility.TableName = "error"; return(dtOfflineUtility); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtOfflineUtility); }
public DataTable SaveOfflineRequest(OfflineUtilityModel ObjOfflineUtilityModel) { DataTable BranchList = ObjOfflineUtilityDA.SaveOfflineRequest(ObjOfflineUtilityModel); return(BranchList); }
public DataTable LoadBranch(OfflineUtilityModel ObjOfflineUtilityModel) { DataTable BranchList = ObjOfflineUtilityDA.LoadBranch(ObjOfflineUtilityModel); return(BranchList); }