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