public CreatedOrderResult OrderCreateV2(OrderCreateModel obj) { ReasonStatusBal _rsbal = new ReasonStatusBal(); CreatedOrderResult objCreateOrderData = new CreatedOrderResult(); int flag = 0; Dictionary <string, int> returndata = new Dictionary <string, int>(); returndata.Add("status", 0); try { System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers; string x_StateName = string.Empty; string x_DistrictName = string.Empty; if (headers.Contains("state")) { x_StateName = headers.GetValues("state").First().ToLower(); } if (headers.Contains("district")) { x_DistrictName = headers.GetValues("district").First().ToLower(); } objCreateOrderData = _rsbal.OrderCreateV2(obj, x_StateName, x_DistrictName); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, obj.userid); } // string json = JsonConvert.SerializeObject(returndata); //HttpContext.Current.Response.ContentType = "application/json; charset=utf-8"; //HttpContext.Current.Response.Write(json); return(objCreateOrderData); }
public DataSet GetCatSubCat(int?KGP_CategoryId = null) { SqlConnection connection; SqlDataAdapter adapter; SqlCommand command = new SqlCommand(); DataSet ds = new DataSet(); connection = new SqlConnection(connetionString); CreatedOrderResult objData = new CreatedOrderResult(); try { DataTable Dt = new DataTable(); connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "[usp_CatSubCat]"; // command.Parameters.AddWithValue("@DTCategory", DTCategory); command.Parameters.AddWithValue("@KGP_CategoryId", KGP_CategoryId); adapter = new SqlDataAdapter(command); adapter.Fill(ds); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } connection.Close(); return(ds); }
public DataSet GetFilterData(DataTable DTSubCategory, string version, string lang, string StateName, string DistrictName) { SqlConnection connection; SqlDataAdapter adapter; SqlCommand command = new SqlCommand(); DataSet ds = new DataSet(); connection = new SqlConnection(connetionString); CreatedOrderResult objData = new CreatedOrderResult(); try { DataTable Dt = new DataTable(); connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "[usp_KitchenGarden_ProductList]"; // command.Parameters.AddWithValue("@DTCategory", DTCategory); command.Parameters.AddWithValue("@DTCategoryFilter", DTSubCategory); command.Parameters.AddWithValue("@version", version); command.Parameters.AddWithValue("@lang", lang); command.Parameters.AddWithValue("@StateName", StateName); command.Parameters.AddWithValue("@x_DistrictName", DistrictName); command.Parameters.AddWithValue("@PageIndex", 1); command.Parameters.AddWithValue("@PageSize", 1000); adapter = new SqlDataAdapter(command); adapter.Fill(ds); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } connection.Close(); return(ds); }
public CreatedOrderResult GetCreateOrderData(int OrderId) { SqlConnection connection; SqlDataAdapter adapter; SqlCommand command = new SqlCommand(); DataSet ds = new DataSet(); connection = new SqlConnection(connetionString); CreatedOrderResult objData = new CreatedOrderResult(); try { DataTable Dt = new DataTable(); connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetSathiOrderAmount"; command.Parameters.AddWithValue("@OrderId", OrderId); adapter = new SqlDataAdapter(command); adapter.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { objData.OrderAmount = Convert.ToDecimal(ds.Tables[0].Rows[0]["OrderAmount"].ToString()); objData.OrderId = OrderId; objData.Status = 1; } } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, OrderId); } connection.Close(); return(objData); }
public CreatedOrderResult OrderCreateV2(OrderCreateModel obj, string x_StateName, string x_DistrictName) { //int id = _rsdal.GetFarmerIdByMobile(mobile); DataTable DT = Helper.Helper.ToDataTable(obj.Product); //CreatedOrderResult objCreateData = _rsdal.OrderCreate(obj.OfferDiscount, obj.Product.PackageId, obj.Product.Quantity, obj.Amount, obj.Farmer.FarmerId, obj.Farmer.Mobile, // obj.Farmer.StateId, obj.Farmer.DistrictId, obj.Farmer.BlockId, obj.Farmer.VillageId, obj.Farmer.OtherVillageName, obj.Farmer.Address, // obj.DeliveryDate, obj.ModeOfPayment, obj.DiscountPrice, obj.DiscountCode); CreatedOrderResult objCreateData = _rsdal.OrderCreateV2(obj.userid, obj.Farmer.FarmerId, obj.Farmer.FarmerName, obj.Farmer.FatherName, obj.Farmer.Mobile, obj.Farmer.StateId, obj.Farmer.DistrictId, obj.Farmer.BlockId, obj.Farmer.VillageId, obj.Farmer.OtherVillageName, obj.Farmer.Address, obj.DeliveryDate, obj.ModeOfPayment, DT, x_StateName, x_DistrictName); return(objCreateData); }
public CreatedOrderResult OrderCreate(int userid, int FarmerId, string FarmerName, string FatherName, long Mobile, int StateId, int DistrictId, int BlockId, int VillageId, string OtherVillageName, string Address, string DeliveryDate, string ModeOfPayment, DataTable DT, string x_StateName, string x_DistrictName) //(int OfferDiscount, int Pckgid, int Qty, int Amount, int FarmerId, long Mobile, int StateId, int DistrictId, int BlockId, // int VillageId, string OtherVillageName, string Address, string DeliveryDate, string ModeOfPayment, int DiscountPrice, string DiscountCode) //, DataTable DT { SqlConnection connection; SqlCommand command = new SqlCommand(); int flag = 0; //string flag = ""; connection = new SqlConnection(connetionString); CreatedOrderResult objDataObject = new CreatedOrderResult(); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "Usp_OrderCreateByBZApp"; command.Parameters.AddWithValue("@SathiId", 0); command.Parameters.AddWithValue("@farmerid", FarmerId); command.Parameters.AddWithValue("@name", FarmerName); command.Parameters.AddWithValue("@fathername", FatherName); command.Parameters.AddWithValue("@mobile", Mobile); command.Parameters.AddWithValue("@stateid", StateId); command.Parameters.AddWithValue("@districtid", DistrictId); command.Parameters.AddWithValue("@blockid", BlockId); command.Parameters.AddWithValue("@villageid", VillageId); command.Parameters.AddWithValue("@othervillagename", OtherVillageName); command.Parameters.AddWithValue("@Address", Address); command.Parameters.AddWithValue("@DeliveryDate", DeliveryDate); command.Parameters.AddWithValue("@ModeOfPayment", ModeOfPayment); command.Parameters.AddWithValue("@Product", DT); command.Parameters.AddWithValue("@x_StateName", x_StateName); command.Parameters.AddWithValue("@x_DistrictName", x_DistrictName); SqlParameter ErrorId = new SqlParameter(); ErrorId.ParameterName = "@Error"; ErrorId.DbType = DbType.Int32; ErrorId.Direction = ParameterDirection.Output; command.Parameters.Add(ErrorId); flag = command.ExecuteNonQuery(); if (flag >= 1) { flag = 1; string Error = command.Parameters["@Error"].Value.ToString(); if (Convert.ToInt32(Error) > 2) { CreatedOrderResult objData = GetCreateOrderData(Convert.ToInt32(Error)); //objDataObject.OrderAmount = 1; //objDataObject.OrderId = 329676; //objDataObject.Status = 1; objDataObject.OrderAmount = objData.OrderAmount; objDataObject.OrderId = Convert.ToInt32(Error); objDataObject.Status = 1; } else { objDataObject.OrderAmount = 0; objDataObject.OrderId = 0; objDataObject.Status = Convert.ToInt32(Error); } } else { flag = 0; string Error = command.Parameters["@Error"].Value.ToString(); objDataObject.OrderAmount = 0; objDataObject.OrderId = 0; objDataObject.Status = 2;// Convert.ToInt32(2); } if (flag == 0) { //string Error = command.Parameters["@Error"].Value.ToString(); //flag = int.Parse(Error);// flag =2 set by error means fo try to create new order to other district so flag =2 objDataObject.OrderAmount = 0; objDataObject.OrderId = 0; objDataObject.Status = 2; } command.Parameters.Clear(); LogDal.MethodCallLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, FarmerId); } connection.Close(); return(objDataObject); }