public static List <BO_ApprovalRights> DA_BindApprovalRights() { BO_ApprovalRights obj = new BO_ApprovalRights(); List <BO_ApprovalRights> list = new List <BO_ApprovalRights>(); DataTable dt = new DataTable(); string[] param = new string[] { "@Mode" }; string[] ParamValues = new string[] { "SELECT" }; dt = SQL_Helper.Select("LongHaul..USP_InsertUpdateAprovalRights", param, ParamValues, "MySqlConnection"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { obj = new BO_ApprovalRights() { RowId = Convert.ToString(dr["Sno"]), appBy = Convert.ToString(dr["appBy"]), Branch = Convert.ToString(dr["Branch"]), Purpose = Convert.ToString(dr["Purpose"]), From_Range = Convert.ToString(dr["From_Range"]), To_Range = Convert.ToString(dr["To_Range"]), From_Days = Convert.ToString(dr["From_Days"]), To_Days = Convert.ToString(dr["To_Days"]), rlavel = Convert.ToString(dr["rlavel"]), EntryBy = Convert.ToString(dr["EntryBy"]), EntryDate = Convert.ToString(dr["EntryDate"]), }; list.Add(obj); } } return(list); }
public static string DA_UpdateApprovalRights(BO_ApprovalRights obj) { string[] param = new string[] { "@Mode", "@Sno", "@appBy", "@Branch", "@Purpose", "@From_Range", "@To_Range", "@From_Days", "@To_Days", "@rlavel", "@EntryBy" }; string[] paramValues = new string[] { "UPDATE", obj.RowId, obj.appBy, obj.Branch, obj.Purpose, obj.From_Range, obj.To_Range, obj.From_Days, obj.To_Days, obj.rlavel, obj.EntryBy }; string message = SQL_Helper.MessageReturn("USP_InsertUpdateAprovalRights", param, paramValues, "MySqlConnection"); return(message); }