public string EditProducts(ProductProperties Ppr)
{
try
{
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@ProductID", Ppr.ProductID));
param.Add(new SqlParameter("@Availabe", Ppr.Available));
param.Add(new SqlParameter("@Remarks", Ppr.Remarks));
//param.Add(new SqlParameter("@ProductName", Ppr.ProductName));
//param.Add(new SqlParameter("@ShortDescription", Ppr.ShortDescription));
//param.Add(new SqlParameter("@LongDescription", Ppr.LongDescription));
//param.Add(new SqlParameter("@Price", Ppr.Price));
//param.Add(new SqlParameter("@Quantity", Ppr.Quantity));
//param.Add(new SqlParameter("@ImageUrl", Ppr.ImageUrl));
//param.Add(new SqlParameter("@SIH", Ppr.SIH));
//param.Add(new SqlParameter("@ReCode", Ppr.Restcode));
//param.Add(new SqlParameter("@Discounts", Ppr.Discounts));
return(_objdal.fnAdddata("spUpdateProdAvailonlyforHN", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public string AddEmployee(EmployeeProperties Epr)
{
try
{
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@First_Name", Epr.First_Name));
param.Add(new SqlParameter("@Last_Name", Epr.Last_Name));
param.Add(new SqlParameter("@Address1", Epr.Address1));
param.Add(new SqlParameter("@Address2", Epr.Address2));
param.Add(new SqlParameter("@Mobile1", Epr.Mobile1));
param.Add(new SqlParameter("@Mobile2", Epr.Mobile2));
param.Add(new SqlParameter("@Active", Epr.Active));
param.Add(new SqlParameter("@RestCode", Epr.RestCode));
param.Add(new SqlParameter("@Remarks", Epr.Remarks));
param.Add(new SqlParameter("@UserTypeId", Epr.UserTypeId));
param.Add(new SqlParameter("@PhotoUrl", Epr.Image));
param.Add(new SqlParameter("@EmailId", Epr.EmailId));
param.Add(new SqlParameter("@UserCode", Epr.UserCode));
// param.Add(new SqlParameter("@EmpCode", Epr.EmpCode));
return(_objdal.fnAdddata("AddEmployee", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
//
public string UpdateTickets(BreakFastProperties b)
{
DataTable dt = new DataTable();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@OrderId", b.OrderId));
param.Add(new SqlParameter("@statusid", b.StatusId));
param.Add(new SqlParameter("@empcode", b.EmpCode));
param.Add(new SqlParameter("@AmtPaid", b.totalamount));
return(_objdal.fnAdddata("[insertOrderTrackingDetailsforpaidtrans]", param.ToArray())); //orderStatusByOrderId
}
public string EditOrders(OrderProperties opr)
{
try
{
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@OrderId", opr.OrderId));
param.Add(new SqlParameter("@statusid", opr.StatusId));
param.Add(new SqlParameter("@empcode", opr.EmpCode));
param.Add(new SqlParameter("@Tip", opr.Tip));
param.Add(new SqlParameter("@Discount", opr.Discount));
param.Add(new SqlParameter("@AmtPaid", opr.AmountPaid));
param.Add(new SqlParameter("@Remarks", opr.Remarks));
return(_objdal.fnAdddata("insertOrderTrackingDetails1", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public string AddNewCustomer(CustomerSearchProperties csp)
{
try
{
SqlCommand com = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@custfname", csp.CustomerFName));
param.Add(new SqlParameter("@custlname", csp.CustomerLName));
param.Add(new SqlParameter("@customerphone", csp.CustPhoneNumber));
param.Add(new SqlParameter("@billaddress", csp.Billing_Address));
param.Add(new SqlParameter("@delivaddress", csp.Delivery_Addresss));
param.Add(new SqlParameter("@landmark", csp.Land_Mark));
param.Add(new SqlParameter("@mobile1", csp.Mobile1));
param.Add(new SqlParameter("@mobile2", csp.Mobile2));
param.Add(new SqlParameter("@custtypeid", csp.CustomerTypeId));
param.Add(new SqlParameter("@delivloclati", csp.DeliveryLocationLatitude));
param.Add(new SqlParameter("@delivloclong", csp.DeliveryLocationLongitude));
return(_objdal.fnAdddata("insertNewCustomer", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}