protected void txtScanner_TextChanged(object sender, EventArgs e)
{
string res = "";
Bookingno = txtScanner.Text.Split('-');
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_StockReconcile";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookingNumber", Bookingno[0]);
cmd.Parameters.AddWithValue("@RowIndex", Bookingno[1]);
cmd.Parameters.AddWithValue("@BranchId", Globals.BranchID);
cmd.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(cmd);
if (res == "Record Saved")
{
lblMsg.Text = "Cloths Found";
bindGrid();
txtScanner.Text = "";
txtScanner.Focus();
}
else
{
lblMsg.Text = "No Cloth Found in Inventory But Found in System or Shop";
bindGrid();
BindDetailGrid();
txtScanner.Text = "";
txtScanner.Focus();
}
}
public string SaveUser(DTO.UserMaster Ob)
{
string res = "";
if (CheckDuplicateUserPin(Ob) == true)
{
res = "User pin is already in Use, Please enter new Pin.";
return(res);
}
if (CheckDuplicateUserBarcode(Ob) == true)
{
res = "User Barcode is already in use, Please change the barcode.";
return(res);
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_UserMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", Ob.UserId);
cmd.Parameters.AddWithValue("@UserPassword", Ob.UserPassword);
cmd.Parameters.AddWithValue("@UserTypeCode", Ob.UserTypeCode);
cmd.Parameters.AddWithValue("@UserBranchCode", Ob.UserBranchCode);
cmd.Parameters.AddWithValue("@UserName", Ob.UserName);
cmd.Parameters.AddWithValue("@UserAddress", Ob.UserAddress);
cmd.Parameters.AddWithValue("@UserPhoneNumber", Ob.UserPhoneNumber);
cmd.Parameters.AddWithValue("@UserMobileNumber", Ob.UserMobileNumber);
cmd.Parameters.AddWithValue("@UserEmailId", Ob.UserEmailId);
cmd.Parameters.AddWithValue("@UserActive", Ob.UserActive);
cmd.Parameters.AddWithValue("@Userbarcode", Ob.UserBarcode);
cmd.Parameters.AddWithValue("@UserPin", Ob.UserPin);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public void SaveTempRecord(GridView grdNewChallan)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_ChallanInProc";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 10);
PrjClass.ExecuteNonQuery(cmd);
string res = string.Empty;
for (int r = 0; r < grdNewChallan.Rows.Count; r++)
{
if (((CheckBox)grdNewChallan.Rows[r].FindControl("chkSelect")).Checked)
{
string[] gridbooking = ((Label)grdNewChallan.Rows[r].FindControl("lblBarcode")).Text.Split('-');
string gridBranchId = gridbooking[2].Replace("*", "").Trim();
string duedate = grdNewChallan.Rows[r].Cells[2].Text;
SqlCommand cmd1 = new SqlCommand();
cmd1.CommandText = "sp_ChallanInProc";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Branchid", gridBranchId);
cmd1.Parameters.AddWithValue("@duedateTime", duedate);
cmd1.Parameters.AddWithValue("@Flag", 11);
res = PrjClass.ExecuteNonQuery(cmd1);
}
}
}
public string DeleteProcessMaster(DTO.ProcessMaster Obj)
{
string res = string.Empty;
int TotalItems = 0;
try
{
TotalItems = CountTotalBooking(Obj);
if (TotalItems > 0)
{
res = "Selected service is in use hence can't be deleted.";
return(res);
}
else
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_sp_ProcessMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProcessCode", Obj.ProcessCode);
cmd.Parameters.AddWithValue("@BranchId", Obj.BID);
cmd.Parameters.AddWithValue("@Flag", 3);
res = PrjClass.ExecuteNonQuery(cmd);
}
}
catch (Exception) { res = ""; }
return(res);
}
public string UpdateBranch(DTO.BranchMaster Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_BranchMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchCode", Ob.BranchCode);
cmd.Parameters.AddWithValue("@BranchName", Ob.BranchName);
cmd.Parameters.AddWithValue("@BranchAddress", Ob.BranchAddress);
cmd.Parameters.AddWithValue("@BranchPhone", Ob.BranchPhone);
cmd.Parameters.AddWithValue("@BranchSlogan", Ob.BranchSlogan);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@IsFactory", Ob.IsBF);
cmd.Parameters.AddWithValue("@IsChallan", Ob.IsChallan);
cmd.Parameters.AddWithValue("@BranchMobile", Ob.BranchMobile);
cmd.Parameters.AddWithValue("@BranchEmail", Ob.BranchEmail);
cmd.Parameters.AddWithValue("@BusinessName", Ob.BusinessName);
cmd.Parameters.AddWithValue("@IsLoginTime", Ob.IsLoginTime);
cmd.Parameters.AddWithValue("@LoginStartTime", Ob.LoginStartTime);
cmd.Parameters.AddWithValue("@LoginEndTime", Ob.LoginEndTime);
cmd.Parameters.AddWithValue("@WeeklyOFF", Ob.WeeklyOFF);
cmd.Parameters.AddWithValue("@Flag", 2);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string UpdateProcessMaster(DTO.ProcessMaster Obj)
{
string res = "";
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_sp_ProcessMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProcessCode", Obj.ProcessCode);
cmd.Parameters.AddWithValue("@ProcessName", Obj.ProcessName);
cmd.Parameters.AddWithValue("@ProcessUsedForVendorReport", Obj.UsedForvendorReport);
cmd.Parameters.AddWithValue("@Discount", Obj.Discount);
cmd.Parameters.AddWithValue("@ServiceTax", Obj.ServiceTax);
cmd.Parameters.AddWithValue("@IsActiveServiceTax", Obj.IsActiveServiceTax);
cmd.Parameters.AddWithValue("@IsDiscount", Obj.IsDiscount);
cmd.Parameters.AddWithValue("@IsChallan", Obj.IsChallanApplicable);
cmd.Parameters.AddWithValue("@ImagePath", Obj.ImagePath);
cmd.Parameters.AddWithValue("@CssTax", Obj.CssTax);
cmd.Parameters.AddWithValue("@EcesjTax", Obj.EcesjTax);
cmd.Parameters.AddWithValue("@IsChallanByPass", Obj.IsReady);
cmd.Parameters.AddWithValue("@BranchId", Obj.BID);
cmd.Parameters.AddWithValue("@Flag", 2);
res = PrjClass.ExecuteNonQuery(cmd);
}
catch (Exception) { res = ""; }
return(res);
}
private string SaveAccountEntries(DTO.Common Ob)
{
string res = string.Empty;
DataTable DTBooking = MainBooking(Ob);
try
{
SqlCommand CMD_Priority = new SqlCommand();
CMD_Priority.CommandText = "sp_NewXmlSave";
CMD_Priority.CommandType = CommandType.StoredProcedure;
CMD_Priority.Parameters.AddWithValue("@TotalCost", DTBooking.Rows[0]["TotalCost"].ToString());
CMD_Priority.Parameters.AddWithValue("@CustomerCode", DTBooking.Rows[0]["BookingByCustomer"].ToString());
CMD_Priority.Parameters.AddWithValue("@AdvanceAmt", DTBooking.Rows[0]["AdvanceAmt"].ToString());
CMD_Priority.Parameters.AddWithValue("@BOOKINGNUMBER", DTBooking.Rows[0]["BookingNumber"].ToString());
ArrayList date = new ArrayList();
date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Ob.BID);
CMD_Priority.Parameters.AddWithValue("@DateTime", date[0].ToString());
CMD_Priority.Parameters.AddWithValue("@Time", date[1].ToString());
CMD_Priority.Parameters.AddWithValue("@BranchId", Ob.BID);
CMD_Priority.Parameters.AddWithValue("@Flag", 3);
res = PrjClass.ExecuteNonQuery(CMD_Priority);
}
catch (Exception ex)
{ res = ex.ToString(); }
return(res);
}
public string SaveRegistration(string CustName, string CustAdd, string CustMob, string Email, string Area, string UserId, string UserPassword, string BranchId)
{
string res = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Proc_Registration";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustomerName", CustName);
cmd.Parameters.AddWithValue("@CustomerAddress", CustAdd);
cmd.Parameters.AddWithValue("@CustomerMobile", CustMob);
cmd.Parameters.AddWithValue("@CustomerEmailId", Email);
cmd.Parameters.AddWithValue("@AreaLocation", Area);
cmd.Parameters.AddWithValue("@UserId", UserId);
cmd.Parameters.AddWithValue("@UserPassword", UserPassword);
cmd.Parameters.AddWithValue("@UserName", CustName);
cmd.Parameters.AddWithValue("@BranchId", BranchId);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string apiupdate(DTO.sms Ob)
{
SqlCommand cmd = new SqlCommand();
string res = string.Empty;
cmd.CommandText = "SP_smsconfig";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userid", Ob.userid);
cmd.Parameters.AddWithValue("@password", Ob.password);
cmd.Parameters.AddWithValue("@api", Ob.api);
cmd.Parameters.AddWithValue("@senderid", Ob.senderid);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@massagedemo", Ob.massagedemo);
cmd.Parameters.AddWithValue("@mobiledemo", Ob.mobiledemo);
cmd.Parameters.AddWithValue("@senderdemo", Ob.senderdemo);
cmd.Parameters.AddWithValue("@useriddemo", Ob.useriddemo);
cmd.Parameters.AddWithValue("@passworddemo", Ob.passworddemo);
cmd.Parameters.AddWithValue("@senderposition", Ob.senderposition);
cmd.Parameters.AddWithValue("@userposition", Ob.userposition);
cmd.Parameters.AddWithValue("@passwordposition", Ob.passwordposition);
cmd.Parameters.AddWithValue("@mobileposition", Ob.mobileposition);
cmd.Parameters.AddWithValue("@massageposition", Ob.massageposition);
cmd.Parameters.AddWithValue("@Flag", 6);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
private string SaveBooking(DTO.Common Ob)
{
string res = string.Empty;
DataSet ds = new DataSet();
DataTable DTBooking = MainBooking(Ob);
SqlCommand CMD_Booking = new SqlCommand();
CMD_Booking.CommandText = "sp_NewXmlSave";
CMD_Booking.CommandType = CommandType.StoredProcedure;
CMD_Booking.Parameters.AddWithValue("@BOOKINGNUMBER", DTBooking.Rows[0]["BookingNumber"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingByCustomer", DTBooking.Rows[0]["BookingByCustomer"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingAcceptedByUserId", DTBooking.Rows[0]["BookingAcceptedByUserId"].ToString());
CMD_Booking.Parameters.AddWithValue("@IsUrgent", DTBooking.Rows[0]["IsUrgent"].ToString());
//CMD_Booking.Parameters.AddWithValue("@BookingDate", DTBooking.Rows[0]["BookingDate"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingDeliveryDate", DTBooking.Rows[0]["BookingDeliveryDate"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingDeliveryTime", DTBooking.Rows[0]["BookingDeliveryTime"].ToString());
CMD_Booking.Parameters.AddWithValue("@TotalCost", DTBooking.Rows[0]["TotalCost"].ToString());
CMD_Booking.Parameters.AddWithValue("@Discount", DTBooking.Rows[0]["Discount"].ToString());
CMD_Booking.Parameters.AddWithValue("@NetAmount", DTBooking.Rows[0]["NetAmount"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingCancelReason", "");
CMD_Booking.Parameters.AddWithValue("@BookingRemarks", DTBooking.Rows[0]["BookingRemarks"].ToString());
CMD_Booking.Parameters.AddWithValue("@ItemTotalQuantity", DTBooking.Rows[0]["ItemTotalQuantity"].ToString());
CMD_Booking.Parameters.AddWithValue("@HomeDelivery", DTBooking.Rows[0]["HomeDelivery"].ToString());
CMD_Booking.Parameters.AddWithValue("@CheckedByEmployee", DTBooking.Rows[0]["CheckedByEmployee"].ToString());
CMD_Booking.Parameters.AddWithValue("@DiscountAmt", DTBooking.Rows[0]["DiscountAmt"].ToString());
CMD_Booking.Parameters.AddWithValue("@DiscountOption", DTBooking.Rows[0]["DiscountOption"].ToString());
CMD_Booking.Parameters.AddWithValue("@BranchId", DTBooking.Rows[0]["BranchId"].ToString());
CMD_Booking.Parameters.AddWithValue("@IsNextTodayUrgent", DTBooking.Rows[0]["IsNextTodayUrgent"].ToString());
CMD_Booking.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(CMD_Booking);
return(res);
}
public void CurrentUser(String UserName)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SP_CurrentUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", UserName);
PrjClass.ExecuteNonQuery(cmd);
}
private void chkStatusRememberMe(string cookies, string BID)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "proc_BindToMachine";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MacId", cookies);
cmd.Parameters.AddWithValue("@BranchId", BID);
cmd.Parameters.AddWithValue("@Flag", 13);
PrjClass.ExecuteNonQuery(cmd);
}
public string delbarcodelable()
{
string res = "";
SqlCommand CMD = new SqlCommand();
CMD.CommandText = "Proc_BarCodeLabels";
CMD.CommandType = CommandType.StoredProcedure;
CMD.Parameters.AddWithValue("@Flag", 8);
res = PrjClass.ExecuteNonQuery(CMD);
return(res);
}
public string DeleteSubItem(DTO.Item Ob)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Item";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OldItemName", Ob.OldItemName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", "5");
Common.Result = PrjClass.ExecuteNonQuery(cmd);
return(Common.Result);
}
public string ItemRename(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Proc_RenameItem";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OldItem", Ob.Input);
cmd.Parameters.AddWithValue("@NewItem", Ob.ChangeName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
Common.Result = PrjClass.ExecuteNonQuery(cmd);
return(Common.Result);
}
public string DeleteExpenses(DTO.Common Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_ExpenseEntryScreen";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", Ob.Id);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 2);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string DeleteBooking(string BranchId, string BookingNo)
{
string res = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Sp_DeleteBooking";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookingNo", BookingNo);
cmd.Parameters.AddWithValue("@BranchId", BranchId);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string DeletePatterns(DTO.Patterns Ob)
{
SqlCommand cmd = new SqlCommand();
string res = string.Empty;
cmd.CommandText = "sp_PatternsMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PatternId", Ob.PatternID);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string DeleteCategory(DTO.Category Ob)
{
SqlCommand cmd = new SqlCommand();
string res = string.Empty;
cmd.CommandText = "sp_Category";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CategoryId", Ob.CategoryID);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string Deletesms(DTO.sms Ob)
{
SqlCommand cmd = new SqlCommand();
string res = string.Empty;
cmd.CommandText = "SP_smsconfig";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SmsId", Ob.SmsId);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string SaveArea(DTO.Common Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Area";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Area", Ob.Input);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string Deletevariation(DTO.Variation Ob)
{
SqlCommand cmd = new SqlCommand();
string res = string.Empty;
cmd.CommandText = "Sp_Variation";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VariationId", Ob.VariationId);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 6);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string UpdateBarcodeLabel(DTO.BacodeLable ob)
{
string res = "";
SqlCommand CMD = new SqlCommand();
CMD.CommandText = "Proc_BarCodeLabels";
CMD.CommandType = CommandType.StoredProcedure;
CMD.Parameters.AddWithValue("@BookingNo", ob.BNO);
CMD.Parameters.AddWithValue("@RowIndex", ob.RowIndex);
CMD.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(CMD);
return(res);
}
public string DeleteReasonMain(DTO.Common Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_RemoveReason";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@ID", Ob.Id);
cmd.Parameters.AddWithValue("@Flag", 7);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string deleteColorMaster(DTO.ColorMaster Ob)
{
string res = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_ColorMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Active", Ob.Active);
cmd.Parameters.AddWithValue("@ColorId", Ob.ColorID);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string deleteHolidayMaster(DTO.Holiday Ob)
{
string res = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Sp_holiday";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Active", Ob.Active);
cmd.Parameters.AddWithValue("@holidayid", Ob.holidayid);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 4);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string SaveInRecurrence(int assignId, DateTime startDate, int cycleDuration, int noOfRecurrence, string branchId)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_PackageMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AssignId", assignId);
cmd.Parameters.AddWithValue("@Recurrence", noOfRecurrence);
cmd.Parameters.AddWithValue("@PageDate", startDate);
cmd.Parameters.AddWithValue("@NoofcycleDuration", cycleDuration);
cmd.Parameters.AddWithValue("@BranchId", branchId);
cmd.Parameters.AddWithValue("@Flag", 43);
return(PrjClass.ExecuteNonQuery(cmd));
}
public string DeleteAssignPackage(DTO.PackageMaster Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_PackageMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustomerCode", Ob.CustomerCode);
cmd.Parameters.AddWithValue("@AssignId", Ob.AssignId);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 16);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string UpdateWeekend(DTO.Holiday Ob)
{
ArrayList date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Ob.BranchId);
string res = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Sp_holiday";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@weeklyoff", Ob.weeklyoff);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
private void UpdateSucessTrue(string cookies, string BID)
{
ArrayList date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(BID);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "proc_BindToMachine";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MacId", cookies);
cmd.Parameters.AddWithValue("@LastLoginDate", date[0]);
cmd.Parameters.AddWithValue("@LastLoginTime", date[1]);
cmd.Parameters.AddWithValue("@BranchId", BID);
cmd.Parameters.AddWithValue("@Flag", 5);
PrjClass.ExecuteNonQuery(cmd);
}