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
        }
Ejemplo n.º 4
0
 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;
     }
 }