/// <summary> /// Method to get CabCapacity /// </summary> /// <returns></returns> public List<CabCapacity> CABTYPELIST() { List<CabCapacity > lstcabcapacity = null; string proc_name = ConstantsDLL.usp_GETCABCAPACITY ; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, null)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbCABCPC = ds.Tables[0]; lstcabcapacity = tbCABCPC.AsEnumerable().Select(CabCpcty => new CabCapacity { capacity = Convert.ToString(CabCpcty["cabcapacity"]) }).ToList(); } } } } return lstcabcapacity; }
/// <summary> /// Method to get CabProperty /// </summary> public List<CabProperty> GetCabProperty() { List<CabProperty> lstgetcabproperty = null; string proc_name = ConstantsDLL.USP_GETCABPROPERTY; using(SqlHelper.SqlHelper db=new SqlHelper.SqlHelper() ) { using (DataSet ds = db.ExecDataSetProc(proc_name, null)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbCabProperty = ds.Tables[0]; lstgetcabproperty = tbCabProperty.AsEnumerable().Select(cabProperty => new CabProperty { PropertyId = Convert.ToInt32(cabProperty["PropertyId"]), PropertyName = Convert.ToString(cabProperty["PropertyName"]), IsCompulsory=Convert.ToBoolean(cabProperty["IsCompulsory"]) }).ToList(); } } } } return lstgetcabproperty; }
/// <summary> /// Method to get CabType /// </summary> /// <param name="CabName"></param> /// <param name="IsActive"></param> /// <returns></returns> public List<CabType> CABTYPELIST( bool? IsActive) { List<CabType> lstcabtype = null; string proc_name = ConstantsDLL.USP_GETCABTYPE; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, null)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbCABTYPE = ds.Tables[0]; lstcabtype = tbCABTYPE.AsEnumerable().Select(Cabtype => new CabType { CABNAME = Convert.ToString(Cabtype["CABNAME"]) }).ToList(); } } } } return lstcabtype; }
public bool CreateRoaster(string Prifix,out string roosternumber) { bool isFlag = false; try { ObjSqlHelper = new SqlHelper.SqlHelper(); string proc_name = ConstantsDLL.USP_CREATEROASTERNO; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@Prefix", Prifix); param[1] = new SqlParameter("@RoosterNumber", SqlDbType.NVarChar, 20); param[1].Direction = ParameterDirection.Output; ObjSqlHelper.ExecNonQueryProc(proc_name, param); roosternumber = param[1].Value.ToString(); if (roosternumber != null && roosternumber !="") isFlag = true; } catch(Exception ex) { isFlag = false; throw; } return isFlag; }
/// <summary> /// Method to get DC list /// </summary> /// <param name="VendorId"></param> /// <param name="IsActive"></param> /// <returns></returns> public List<DC> GetDCList() { List<DC> lstDC = null; string proc_name = ConstantsDLL.USP_GETDCLIST; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, null)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbDCs = ds.Tables[0]; lstDC = tbDCs.AsEnumerable().Select(vendor => new DC { DCID = Convert.ToInt32(vendor["DCID"]), DCName = Convert.ToString(vendor["DCName"]), IsActive = Convert.ToInt32(vendor["IsActive"]), CreatedDate = Convert.ToString(vendor["CreatedDate"]), CreatedBy = Convert.ToString(vendor["CreatedBy"]), ModifiedDate = Convert.ToString(vendor["ModifiedDate"]), ModifiedBy = Convert.ToString(vendor["ModifiedBy"]) }).ToList(); } } } } return lstDC; }
/// <summary> /// Method to get RoleDetail /// </summary> /// <returns></returns> public List<RoleDetail> GetRoleDetail() { List<RoleDetail> lstroledetail = null; string proc_name = ConstantsDLL.USP_GETROLEDETAIL; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, null)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbRoleDeatil = ds.Tables[0]; lstroledetail = tbRoleDeatil.AsEnumerable().Select(roledetail => new RoleDetail { RoleId = Convert.ToInt32(roledetail["RoleId"]), RoleName = Convert.ToString(roledetail["RoleName"]), RoleAccess = Convert.ToString(roledetail["RoleAccess"]), CreatedDate = Convert.ToString(roledetail["CreatedDate"]), CreatedBy = Convert.ToString(roledetail["CreatedBy"]), ModifiedDate = Convert.ToString(roledetail["ModifiedDate"]), ModifiedBy = Convert.ToString(roledetail["ModifiedBy"]), IsActive = Convert.ToBoolean(roledetail["IsActive"]) }).ToList(); } } } } return lstroledetail; }
public bool CancelRequest(int RequestId) { string proc_name = ConstantsDLL.USP_CANCELONDEMANDREQUEST; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@OnDemandID", RequestId); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } return true; }
/// <summary> /// Method to make ActiveInActive Driver /// </summary> /// <param name="vendor"></param> /// <returns></returns> public bool ActiveInactiveDriverDeatil(string DriverId, bool ActiveInactive, string ModifiedBy) { string proc_name = ConstantsDLL.USP_ActiveInactiveDriver; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@DriverId", DriverId); param[1] = new SqlParameter("@IsActive", ActiveInactive); param[2] = new SqlParameter("@ModifiedBy", ModifiedBy); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } return true; }
public bool DeleteDC(string DCId, bool IsActive, string Modifiedby) { ObjSqlHelper = new SqlHelper.SqlHelper(); string proc_name = ConstantsDLL.USP_DELETEDC; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@DCId", DCId); param[1] = new SqlParameter("@IsActive", IsActive); param[2] = new SqlParameter("@ModifyBy", Modifiedby); ObjSqlHelper.ExecNonQueryProc(proc_name, param); return true; }
/// <summary> /// Method to active or deactivate the vendor with comment option /// </summary> /// <param name="VendorId"></param> /// <param name="IsActive"></param> /// <param name="IsActiveComment"></param> /// <param name="ModifiedBy"></param> /// <returns></returns> public bool Active_InactiveVendor(string VendorIds,bool IsActive,string IsActiveComment,string ModifiedBy) { string proc_name = ConstantsDLL.USP_ACTIVEINACTIVEVENDOR; SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@VendorIDs",VendorIds); param[1] = new SqlParameter("@IsActive",IsActive); param[2] = new SqlParameter("@IsActiveComment", IsActiveComment); param[3] = new SqlParameter("@ModifiedBy", ModifiedBy); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } return true; }
/// <summary> /// Method to Delete RoleDetail /// </summary> /// <returns></returns> public bool DeleteRole(string RoleId, bool IsActive, string Modifiedby) { ObjSqlHelper = new SqlHelper.SqlHelper(); string proc_name = ConstantsDLL.USP_ACTIVEINACTIVEROLE; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@RoleId", RoleId); param[1] = new SqlParameter("@IsActive", IsActive); param[2] = new SqlParameter("@ModifyBy", Modifiedby); ObjSqlHelper.ExecNonQueryProc(proc_name, param); return true; }
/// <summary> /// Method to Get List of Driver DETAIL /// </summary> /// <returns></returns> /// public List<DriverDetail> GetDriverDetails(int DCID, bool ? IsActive) { List<DriverDetail> lstdriverdetails = null; string proc_name = ConstantsDLL.usp_GetDriverDetailsAccToDC; SqlParameter[] param = new SqlParameter[2]; //if(DriverCode==string.Empty) //{ // param[0] = new SqlParameter("@DriverCode", null); //} //else //{ // param[0] = new SqlParameter("@DriverCode", DriverCode); //} param[0] = new SqlParameter("@DCID", DCID); param[1] = new SqlParameter("@IsActive", IsActive); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, param)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbDriverDetails = ds.Tables[0]; lstdriverdetails = tbDriverDetails.AsEnumerable().Select(DriverDetails => new DriverDetail { DriverId =Convert.ToInt32( DriverDetails["DriverId"].ToString()), DriverCode = DriverDetails["DriverCode"].ToString(), DriverName = DriverDetails["DriverName"].ToString(), DCName= DriverDetails["DCName"].ToString(), //EmpanelDate = (Convert.ToDateTime(DriverDetails["EmpanelDate"])).ToString("MMM dd,yyyy"), //CreatedBy = DriverDetails["CreatedBy"].ToString(), //ModifyDate = (Convert.ToDateTime(DriverDetails["ModifyDate"])).ToString("MMM dd,yyyy"), //ModifyBy = DriverDetails["ModifyBy"].ToString(), IsActive =Convert.ToBoolean(DriverDetails["IsActive"].ToString()) }).ToList(); } } } return lstdriverdetails; } }
public bool ActiveInactiveUser(string UserID, bool ActiveInactive, string ModifiedBy) { string proc_name = ConstantsDLL.USP_ACTIVEINACTIVEUSER; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@OndemandRequestID", UserID); param[1] = new SqlParameter("@IsActive", ActiveInactive); param[2] = new SqlParameter("@ModifiedBy", ModifiedBy); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } return true; }
public bool Active_InactiveShift(string ShiftIds, bool IsActive, string ModifiedBy) { string proc_name = ConstantsDLL.USP_ACTIVEINACTIVESHIFT; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@ShiftIds", ShiftIds); param[1] = new SqlParameter("@IsActive",IsActive); param[2] = new SqlParameter("@ModifiedBy",ModifiedBy); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } return true; }
public bool ApproveUserRequest(string UserId, string ModifiedBy, string Comment) { string proc_name = ConstantsDLL.USP_APPROVEUSERREQUEST; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@OndemandRequestID", UserId); param[1] = new SqlParameter("@ModifiedBy", ModifiedBy); param[2] = new SqlParameter("@Comment", Comment); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } return true; }
public List<Shift> GetShiftList(Shift objShift) { List<Shift> lstShift = null; string proc_name = ConstantsDLL.USP_GETSHIFTINFO; SqlParameter[] param = new SqlParameter[4]; if(objShift.ShiftId==0) { param[0] = new SqlParameter("@ShiftId", null); } else { param[0] = new SqlParameter("@ShiftId", objShift.ShiftId); } param[1] = new SqlParameter("@ShiftType", objShift.ShiftType); param[2] = new SqlParameter("@ShiftCategory", objShift.ShiftCategory); param[3] = new SqlParameter("@IsActive", objShift.IsActive); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, param)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbShift = ds.Tables[0]; lstShift = tbShift.AsEnumerable().Select(shift => new Shift { ShiftId = Convert.ToInt32(shift["ShiftId"]), ShiftType = Convert.ToString(shift["ShiftType"]), ShiftCategory = Convert.ToString(shift["ShiftCategory"]), ShiftTime =DateTime.Parse(shift["ShiftTime"].ToString()).ToString("HH:mm"), DcName = Convert.ToString(shift["DCName"]), IsActive=Convert.ToBoolean(shift["IsActive"]) }).ToList(); } } } } return lstShift; }
public Int32 DeleteRouteMaster(RouteMaster ObjRouteMaster) { ObjSqlHelper = new SqlHelper.SqlHelper(); SqlParameter[] oPara = { new SqlParameter("@DPID", SqlDbType.VarChar), new SqlParameter("@IsActive", SqlDbType.Int), new SqlParameter("@ModifiedBy", SqlDbType.VarChar), new SqlParameter("@Rval", SqlDbType.Int) }; oPara[0].Value = ObjRouteMaster.RouteIDs; oPara[0].Size = 255; oPara[1].Value = ObjRouteMaster.IsActive; oPara[1].Size = 155; oPara[2].Value = ObjRouteMaster.ModifiedBy; oPara[2].Size = 255; oPara[3].Direction = ParameterDirection.ReturnValue; ObjSqlHelper.ExecNonQueryProc(ConstantsDLL.USP_DeleteRoute, oPara); return Convert.ToInt32(oPara[3].Value); }
/// <summary> /// Method to get Backend Record For Validate Roster /// </summary> /// <returns></returns> public DataSet RecordForValidateRoster() { DataSet RecordForValidateDS = new DataSet(); string proc_name = ConstantsDLL.USP_GETRECORDFORROSTER; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, null)) { if (ds != null) { RecordForValidateDS = ds; } } } return RecordForValidateDS; }
public List<RouteMaster> GetAllPointsByRoute(string RouteName) { try { List<RouteMaster> list = null; SqlParameter[] opara = { new SqlParameter("@RouteName",RouteName) }; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(ConstantsDLL.USP_GETPOINTSBYROUTE, opara)) { if (ds != null) { list = ds.Tables[0].AsEnumerable().Select(x => new RouteMaster { RouteID = (Int32)(x["RouteID"]), //RouteName = (string)(x["RouteName"] ?? ""), DropPoint = (string)(x["DropPoint"] == null || x["DropPoint"] == DBNull.Value ? string.Empty : x["DropPoint"].ToString()), //DCID = (Int32)(x["DCID"] ?? ""), // DCName = (string)(x["DCName"] ?? ""), //IsActive = (Boolean)(x["IsActive"] ?? "") }).ToList(); return list; } else { return list; } } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to get vendor list by their status /// </summary> /// <param name="VendorId"></param> /// <param name="IsActive"></param> /// <returns></returns> public List<Vendor> GetVendorList(Int32? VendorId, bool? IsActive) { List<Vendor> lstVendor = null; string proc_name = ConstantsDLL.USP_GETVENDORLIST; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@VendorID", VendorId); param[1] = new SqlParameter("@IsActive", IsActive); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, param)) { if (ds != null) { if(ds.Tables[0].Rows.Count>0) { DataTable tbVendor = ds.Tables[0]; lstVendor = tbVendor.AsEnumerable().Select(vendor => new Vendor { VendorID = Convert.ToInt32(vendor["VendorID"]), VendorName = Convert.ToString(vendor["VendorName"]), Address = Convert.ToString(vendor["Address"]), City = Convert.ToString(vendor["City"]), EmpanelDate = (Convert.ToDateTime(vendor["EmpanelDate"])).ToString("MMM dd,yyyy"), DCName = Convert.ToString(vendor["DCName"]), Comment = Convert.ToString(vendor["Comment"]), CreatedBy = Convert.ToString(vendor["CreatedBy"]), CreatedDate = Convert.ToDateTime(vendor["CreatedDate"]), IsActive = Convert.ToBoolean(vendor["IsActive"]) }).ToList(); } } } } return lstVendor; }
public string UpdateShift(Shift shift) { string proc_name = ConstantsDLL.USP_UPDATESHIFTINFO; SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@ShiftId", shift.ShiftId); param[1] = new SqlParameter("@ShiftCategory", shift.ShiftCategory); param[2] = new SqlParameter("@ShiftType",shift.ShiftType); param[3] = new SqlParameter("@ShiftTime",shift.ShiftTime); param[4] = new SqlParameter("@DCID", shift.DCID); param[5] = new SqlParameter("@ModifiedBy",shift.ModifiedBy); string Result = ""; param[6] = new SqlParameter("@Result", SqlDbType.VarChar, 50, Result); param[6].Direction = ParameterDirection.Output; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } Result = Convert.ToString(param[6].Value); return Result; }
/// <summary> /// Method to make modification in vendor /// </summary> /// <param name="vendor"></param> /// <returns></returns> public Int32 UpdateVendor(Vendor vendor) { ObjSqlHelper = new SqlHelper.SqlHelper(); SqlParameter[] oPara = { new SqlParameter("@VendorID", SqlDbType.Int), new SqlParameter("@VendorName", SqlDbType.VarChar), new SqlParameter("@Address", SqlDbType.VarChar), new SqlParameter("@City", SqlDbType.VarChar), new SqlParameter("@EmpanelDate",SqlDbType.VarChar), new SqlParameter("@DCID", SqlDbType.Int), new SqlParameter("Comment",SqlDbType.VarChar), new SqlParameter("ModifiedBy",SqlDbType.VarChar), new SqlParameter("@Rval", SqlDbType.Int) }; oPara[0].Value = vendor.VendorID; oPara[0].Size = 155; oPara[1].Value = vendor.VendorName.Trim(); oPara[1].Size = 155; oPara[2].Value = vendor.Address; oPara[2].Size = 255; oPara[3].Value = vendor.City; oPara[3].Size=255; oPara[4].Value = vendor.EmpanelDate; oPara[4].Size = 255; oPara[5].Value = vendor.DCID; oPara[5].Size = 255; oPara[6].Value = vendor.Comment; oPara[6].Size = 255; oPara[7].Value = vendor.ModifiedBy; oPara[7].Size = 255; oPara[8].Direction = ParameterDirection.ReturnValue; ObjSqlHelper.ExecNonQueryProc(ConstantsDLL.USP_UPDATEVENDOR, oPara); return Convert.ToInt32(oPara[8].Value); }
/// <summary> /// Method to insert the details for creating new vendor /// </summary> /// <param name="vendor"></param> /// <returns></returns> public int InsertVendor(Vendor vendor) { //string proc_name = ConstantsDLL.USP_INSERTVENDOR; ObjSqlHelper = new SqlHelper.SqlHelper(); SqlParameter[] param = { new SqlParameter("@VendorName",SqlDbType.VarChar), new SqlParameter("@Address",SqlDbType.VarChar), new SqlParameter("@City", SqlDbType.VarChar), new SqlParameter("@EmpanelDate",SqlDbType.Date), new SqlParameter("@DCID", SqlDbType.Int), new SqlParameter("@Comment",SqlDbType.VarChar), new SqlParameter("@CreatedBy",SqlDbType.VarChar), new SqlParameter("@rVal",SqlDbType.Int) }; param[0].Value = vendor.VendorName; param[0].Size = 255; param[1].Value = vendor.Address; param[1].Size = 155; param[2].Value = vendor.City; param[2].Size = 255; param[3].Value = vendor.EmpanelDate; param[3].Size = 255; param[4].Value = vendor.DCID; param[4].Size = 155; param[5].Value = vendor.Comment; param[5].Size = 255; param[6].Value = vendor.CreatedBy; param[6].Size = 255; param[7].Direction = ParameterDirection.ReturnValue; ObjSqlHelper.ExecNonQueryProc(ConstantsDLL.USP_INSERTVENDOR, param); //using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) //{ // db.ExecNonQueryProc(proc_name, param); //} //return true; return Convert.ToInt32(param[7].Value); }
public List<Vendor> GetVendorList(Int32? VendorId, bool? IsActive,int DCID) { List<Vendor> lstVendor = null; string proc_name = ConstantsDLL.USP_GETVENDORLISTACCTODC; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@VendorID", VendorId); param[1] = new SqlParameter("@IsActive", IsActive); param[2] = new SqlParameter("@DCID", DCID); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, param)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbVendor = ds.Tables[0]; lstVendor = tbVendor.AsEnumerable().Select(vendor => new Vendor { VendorID = Convert.ToInt32(vendor["VendorID"]), VendorName = Convert.ToString(vendor["VendorName"]), IsActive = Convert.ToBoolean(vendor["IsActive"]) }).ToList(); } } } } return lstVendor; }
/// <summary> /// Method to insert the details for creating new request /// </summary> /// <param name="vendor"></param> /// <returns></returns> public bool InsertRequest(OnDemandRequest request) { string proc_name = ConstantsDLL.USP_INSERTNEWREQUEST; SqlParameter[] param = new SqlParameter[15]; param[0] = new SqlParameter("@RequestType", request.RequestType); param[1] = new SqlParameter("@ReoccuringRequestId", request.ReoccuringRequest); param[2] = new SqlParameter("@ToDate", request.toDate); param[3] = new SqlParameter("@EmailId", request.EmailId); param[4] = new SqlParameter("@BookingType", request.BookingType); param[5] = new SqlParameter("@Gender", request.Gender); param[6] = new SqlParameter("@RouteId", request.RouteId); param[7] = new SqlParameter("@RequestedDate", request.RequestedDate); param[8] = new SqlParameter("@RequestedTime", System.Data.SqlDbType.Time,50); param[8].Value = request.RequestedTime; param[9] = new SqlParameter("@Address", request.Address); param[10] = new SqlParameter("@Mobile", request.Mobile); param[11] = new SqlParameter("@RequestRemarks", request.RequestRemarks); param[12] = new SqlParameter("@CreatedBy", request.CreatedBy); param[13] = new SqlParameter("@DCID", request.DCID); param[14] = new SqlParameter("@Approver", request.Approver); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } return true; }
public bool UpdateRequest(OnDemandRequest Request) { string proc_name = ConstantsDLL.USP_UPDATEONDEMANDREQUEST; SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@OnDemandID", Request.OndemandRequestId); param[1] = new SqlParameter("@Approver", Request.Approver); param[2] = new SqlParameter("@Address", Request.Address); // param[3] = new SqlParameter("@RequestedDate", Request.RequestedDate); param[3] = new SqlParameter("@RequestedDate", System.Data.SqlDbType.Date, 50); param[3].Value =Convert.ToDateTime(Request.RequestedDate); param[4] = new SqlParameter("@RequestedTime", Request.RequestedTime); param[5] = new SqlParameter("@ApproverRemarks", Request.RequestRemarks); param[6] = new SqlParameter("@RequestType", Request.RequestType); // param[7] = new SqlParameter("@RouteName", Request.RouteName); param[7] = new SqlParameter("@BookingType", Request.BookingType); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { db.ExecNonQueryProc(proc_name, param); } return true; }
public List<Shift> GetShiftListByDC(int DCId, string ShiftType, string RequestType) { List<Shift> lstShift = null; string proc_name = ConstantsDLL.USP_GETSHIFTDETAILBYDC; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@DCID", DCId); param[1] = new SqlParameter("@ShiftType", ShiftType); param[2] = new SqlParameter("@RequestType", RequestType); using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { using (DataSet ds = db.ExecDataSetProc(proc_name, param)) { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable tbShift = ds.Tables[0]; lstShift = tbShift.AsEnumerable().Select(shift => new Shift { ShiftId = Convert.ToInt32(shift["ShiftId"]), ShiftCategory = Convert.ToString(shift["ShiftCategory"]), //corrected by piyush ShiftType = Convert.ToString(shift["ShiftType"]), ShiftTime = DateTime.Parse(shift["ShiftTime"].ToString()).ToString("HH:mm"), }).ToList(); } } } } return lstShift; }
public DataSet CheckRecords(string EmailId, int RouteId, DateTime RequestedDate) { DataSet lstCabdetail = null; string proc_name = ConstantsDLL.usp_CheckRecords; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@UserCode", EmailId); param[1] = new SqlParameter("@RouteId", RouteId); param[2] = new SqlParameter("@RequestedDate", RequestedDate); //string Query = "select * from OnDemandRequests where OndemandRequestId=(select max(OndemandRequestId) from OnDemandRequests where EmailId='" + EmailId + "')"; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) { lstCabdetail = db.ExecDataSetProc(proc_name, param); } return lstCabdetail; }
public string InsertDC(DC roledetail) { string outResult = string.Empty; ObjSqlHelper = new SqlHelper.SqlHelper(); string proc_name = ConstantsDLL.USP_INSERTDC; SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@DCName", roledetail.DCName); param[1] = new SqlParameter("@IsActive", roledetail.IsActive); param[2] = new SqlParameter("@CreatedBy", roledetail.CreatedBy); param[3] = new SqlParameter("@Result", outResult); param[3].Direction = ParameterDirection.Output; ObjSqlHelper.ExecNonQueryProc(proc_name, param); outResult = Convert.ToString(param[3].Value); // ObjSqlHelper.ExecNonQueryProc(proc_name, param); return outResult; }
public string UpdateDC(DC roledetail) { ObjSqlHelper = new SqlHelper.SqlHelper(); string proc_name = ConstantsDLL.USP_UPDATEDC; SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@DCId", roledetail.DCID); param[1] = new SqlParameter("@IsActive", roledetail.IsActive); param[2] = new SqlParameter("@ModifyBy", roledetail.ModifiedBy); param[3] = new SqlParameter("@DCName", roledetail.DCName); string Result = ""; param[4] = new SqlParameter("@Result", SqlDbType.VarChar, 50, Result); param[4].Direction = ParameterDirection.Output; using (SqlHelper.SqlHelper db = new SqlHelper.SqlHelper()) // ObjSqlHelper.ExecNonQueryProc(proc_name, param); { db.ExecNonQueryProc(proc_name, param); } Result = Convert.ToString(param[4].Value); return Result; // return true; }