public SaleOrderDetail GetSaleOrder(string fromdate, string todate, string Mode, string DistrictId, int UserID, int stateId)
{
DataSet ds = _rsdal.GetSaleOrder(fromdate, todate, Mode, DistrictId, UserID, stateId);
SaleOrderDetail SaleOD = new SaleOrderDetail();
if (ds != null && ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
List <SaleOrderList> _Sale = new List <SaleOrderList>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[i]["SALECOUNT"].ToString()))
{
SaleOrderList SaleO = new SaleOrderList();
if (Mode.ToUpper().Trim() == "USERWISE")
{
SaleO.UserId = Convert.ToInt32(ds.Tables[0].Rows[i]["UserID"].ToString());
}
SaleO.CategoryName = ds.Tables[0].Rows[i]["CategoryName"].ToString();
SaleO.SaleCount = ds.Tables[0].Rows[i]["SALECOUNT"].ToString();
SaleO.SaleValue = Convert.ToDecimal(ds.Tables[0].Rows[i]["SALEVALUE"].ToString());
_Sale.Add(SaleO);
}
}
SaleOD.SaleList = _Sale;
}
}
return(SaleOD);
}
private SaleOrderDetail CreateObject(NullHandler oReader)
{
SaleOrderDetail oSaleOrderDetail = new SaleOrderDetail();
MapObject(oSaleOrderDetail, oReader);
return(oSaleOrderDetail);
}
public SaleOrderDetail GetByID(int nID)
{
SaleOrderDetail oSaleOrderDetail = new SaleOrderDetail();
try
{
SqlCommand cmd = new SqlCommand("SP_SaleOrderDetail_GetByID", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SaleID", SqlDbType.Int)).Value = nID;
if (_conn.State == ConnectionState.Open)
{
}
else
{
cmd.Connection.Open();
}
IDataReader reader = cmd.ExecuteReader();
NullHandler oReader = new NullHandler(reader);
if (reader.Read())
{
oSaleOrderDetail = CreateObject(oReader);
}
cmd.Dispose();
cmd.Connection.Close();
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(oSaleOrderDetail);
}
private SaleOrderDetails CreateObjects(IDataReader oReader)
{
SaleOrderDetails oSaleOrderDetails = new SaleOrderDetails();
NullHandler oHandler = new NullHandler(oReader);
while (oReader.Read())
{
SaleOrderDetail oItem = CreateObject(oHandler);
oSaleOrderDetails.Add(oItem);
}
return(oSaleOrderDetails);
}
public ID Save(SaleOrderDetail oSaleOrderDetail)
{
try
{
if (oSaleOrderDetail.IsNew)
{
SqlCommand cmd = new SqlCommand("SP_SaleOrderDetail_Insert", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SONumber", SqlDbType.VarChar)).Value = oSaleOrderDetail.SONumber;
cmd.Parameters.Add(new SqlParameter("@saleDate", SqlDbType.Date)).Value = oSaleOrderDetail.saleDate;
cmd.Parameters.Add(new SqlParameter("@PONumber", SqlDbType.VarChar)).Value = oSaleOrderDetail.PONumber;
cmd.Parameters.Add(new SqlParameter("@printBillRef", SqlDbType.VarChar)).Value = oSaleOrderDetail.printBillRef;
cmd.Parameters.Add(new SqlParameter("@memoNo", SqlDbType.VarChar)).Value = oSaleOrderDetail.memoNo;
cmd.Parameters.Add(new SqlParameter("@Pro_ID", SqlDbType.Int)).Value = oSaleOrderDetail.Pro_ID;
cmd.Parameters.Add(new SqlParameter("@discount", SqlDbType.Decimal)).Value = oSaleOrderDetail.discount;
cmd.Parameters.Add(new SqlParameter("@newCus", SqlDbType.VarChar)).Value = oSaleOrderDetail.newCus;
cmd.Parameters.Add(new SqlParameter("@PartyID", SqlDbType.VarChar)).Value = oSaleOrderDetail.PartyID;
cmd.Parameters.Add(new SqlParameter("@prodUnit", SqlDbType.VarChar)).Value = oSaleOrderDetail.prodUnit;
cmd.Parameters.Add(new SqlParameter("@bagQty", SqlDbType.Decimal)).Value = oSaleOrderDetail.bagQty;
cmd.Parameters.Add(new SqlParameter("@unitPrice", SqlDbType.Decimal)).Value = oSaleOrderDetail.unitPrice;
cmd.Parameters.Add(new SqlParameter("@unitPerBag", SqlDbType.Decimal)).Value = oSaleOrderDetail.unitPerBag;
cmd.Parameters.Add(new SqlParameter("@transportCost", SqlDbType.Decimal)).Value = oSaleOrderDetail.transportCost;
cmd.Parameters.Add(new SqlParameter("@returnQty", SqlDbType.Decimal)).Value = oSaleOrderDetail.returnQty;
cmd.Parameters.Add(new SqlParameter("@totalSaleQty", SqlDbType.Decimal)).Value = oSaleOrderDetail.totalSaleQty;
cmd.Parameters.Add(new SqlParameter("@totalAmount", SqlDbType.Decimal)).Value = oSaleOrderDetail.totalAmount;
cmd.Parameters.Add(new SqlParameter("@comments", SqlDbType.VarChar)).Value = oSaleOrderDetail.comments;
cmd.Parameters.Add(new SqlParameter("@DBUserID", SqlDbType.Int)).Value = EMSGlobal._nCurrentUserID;
if (_conn.State == ConnectionState.Open)
{
}
else
{
cmd.Connection.Open();
}
int NewID = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
cmd.Connection.Close();
BusinessObject.Factory.SetID(oSaleOrderDetail, new ID(NewID));
}
BusinessObject.Factory.SetObjectState(oSaleOrderDetail, ObjectState.Saved);
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(oSaleOrderDetail.ID);
}
public SaleOrderDetail GetSaleOrder(string apiKey, string fromdate, string todate, string Mode, string DistrictId = "0", int UserID = 0, int stateId = 6)
{
SaleOrderDetail ord = null;
if (apiKey == ConfigurationManager.AppSettings["reasonkey"])
{
try
{
ord = _agentbal.GetSaleOrder(fromdate, todate, Mode, DistrictId, UserID, stateId);
}
catch (Exception ex)
{
LogBal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0);
}
}
return(ord);
}
private void MapObject(SaleOrderDetail oSaleOrderDetail, NullHandler oReader)
{
BusinessObject.Factory.SetID(oSaleOrderDetail, new ID(oReader.GetInt32("SaleID")));
oSaleOrderDetail.SONumber = oReader.GetString("SONumber");
oSaleOrderDetail.saleDate = oReader.GetDateTime("saleDate");
oSaleOrderDetail.PONumber = oReader.GetString("PONumber");
oSaleOrderDetail.printBillRef = oReader.GetString("printBillRef");
oSaleOrderDetail.memoNo = oReader.GetString("memoNo");
oSaleOrderDetail.Pro_ID = oReader.GetInt32("Pro_ID");
oSaleOrderDetail.discount = oReader.GetDouble("discount");
oSaleOrderDetail.newCus = oReader.GetString("newCus");
oSaleOrderDetail.newCusContact = oReader.GetString("newCusContact");
oSaleOrderDetail.PartyID = oReader.GetString("PartyID");
oSaleOrderDetail.prodUnit = oReader.GetString("prodUnit");
oSaleOrderDetail.bagQty = oReader.GetDouble("bagQty");
oSaleOrderDetail.unitPrice = oReader.GetDouble("unitPrice");
oSaleOrderDetail.unitPerBag = oReader.GetDouble("unitPerBag");
oSaleOrderDetail.transportCost = oReader.GetDouble("transportCost");
oSaleOrderDetail.returnQty = oReader.GetDouble("returnQty");
oSaleOrderDetail.totalSaleQty = oReader.GetDouble("totalSaleQty");
oSaleOrderDetail.totalAmount = oReader.GetDouble("totalAmount");
oSaleOrderDetail.comments = oReader.GetString("comments");
BusinessObject.Factory.SetObjectState(oSaleOrderDetail, ObjectState.Saved);
}
public bool UpDateSaleOrderDetail(SaleOrderDetail oSaleOrderDetail, int nEditID)
{
try
{
SqlCommand cmd = new SqlCommand("SP_SaleOrderDetail_Update", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SONumber", SqlDbType.VarChar)).Value = oSaleOrderDetail.SONumber;
cmd.Parameters.Add(new SqlParameter("@saleDate", SqlDbType.Date)).Value = oSaleOrderDetail.saleDate;
cmd.Parameters.Add(new SqlParameter("@PONumber", SqlDbType.VarChar)).Value = oSaleOrderDetail.PONumber;
cmd.Parameters.Add(new SqlParameter("@printBillRef", SqlDbType.VarChar)).Value = oSaleOrderDetail.printBillRef;
cmd.Parameters.Add(new SqlParameter("@memoNo", SqlDbType.VarChar)).Value = oSaleOrderDetail.memoNo;
cmd.Parameters.Add(new SqlParameter("@Pro_ID", SqlDbType.Int)).Value = oSaleOrderDetail.Pro_ID;
cmd.Parameters.Add(new SqlParameter("@discount", SqlDbType.Decimal)).Value = oSaleOrderDetail.discount;
cmd.Parameters.Add(new SqlParameter("@newCus", SqlDbType.VarChar)).Value = oSaleOrderDetail.newCus;
cmd.Parameters.Add(new SqlParameter("@PartyID", SqlDbType.VarChar)).Value = oSaleOrderDetail.PartyID;
cmd.Parameters.Add(new SqlParameter("@prodUnit", SqlDbType.VarChar)).Value = oSaleOrderDetail.prodUnit;
cmd.Parameters.Add(new SqlParameter("@bagQty", SqlDbType.Decimal)).Value = oSaleOrderDetail.bagQty;
cmd.Parameters.Add(new SqlParameter("@unitPrice", SqlDbType.Decimal)).Value = oSaleOrderDetail.unitPrice;
cmd.Parameters.Add(new SqlParameter("@unitPerBag", SqlDbType.Decimal)).Value = oSaleOrderDetail.unitPerBag;
cmd.Parameters.Add(new SqlParameter("@transportCost", SqlDbType.Decimal)).Value = oSaleOrderDetail.transportCost;
cmd.Parameters.Add(new SqlParameter("@returnQty", SqlDbType.Decimal)).Value = oSaleOrderDetail.returnQty;
cmd.Parameters.Add(new SqlParameter("@totalSaleQty", SqlDbType.Decimal)).Value = oSaleOrderDetail.totalSaleQty;
cmd.Parameters.Add(new SqlParameter("@totalAmount", SqlDbType.Decimal)).Value = oSaleOrderDetail.totalAmount;
cmd.Parameters.Add(new SqlParameter("@comments", SqlDbType.VarChar)).Value = oSaleOrderDetail.comments;
cmd.Parameters.Add(new SqlParameter("@DBUUID", SqlDbType.Int)).Value = EMSGlobal._nCurrentUserID;
cmd.Parameters.Add(new SqlParameter("@SaleID", SqlDbType.Int)).Value = nEditID;
if (_conn.State == ConnectionState.Open)
{
}
else
{
cmd.Connection.Open();
}
cmd.ExecuteNonQuery();
cmd.Dispose();
cmd.Connection.Close();
return(true);
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
}
partial void SaleOrderDetails_Inserting(SaleOrderDetail entity)
{
entity.UnitCost = Convert.ToDecimal(entity.UnitCost.ToString("G7", CultureInfo.InvariantCulture));
}
partial void SaleOrderDetails_Inserted(SaleOrderDetail entity)
{
updateReserveStockOnHand(entity.Location, entity.Product, entity.LotNo, entity.OrderQuantity);
}
public void AddToSaleOrderDetails(SaleOrderDetail saleOrderDetail)
{
base.AddObject("SaleOrderDetails", saleOrderDetail);
}
public static SaleOrderDetail CreateSaleOrderDetail(int ID, int saleOrderDetail_SaleOrder, int saleOrderDetail_Product, int saleOrderDetail_Location, string lotNo, double orderQuantity, decimal masterSalePrice, decimal unitCost, decimal salePrice, byte[] rowVersion)
{
SaleOrderDetail saleOrderDetail = new SaleOrderDetail();
saleOrderDetail.Id = ID;
saleOrderDetail.SaleOrderDetail_SaleOrder = saleOrderDetail_SaleOrder;
saleOrderDetail.SaleOrderDetail_Product = saleOrderDetail_Product;
saleOrderDetail.SaleOrderDetail_Location = saleOrderDetail_Location;
saleOrderDetail.LotNo = lotNo;
saleOrderDetail.OrderQuantity = orderQuantity;
saleOrderDetail.MasterSalePrice = masterSalePrice;
saleOrderDetail.UnitCost = unitCost;
saleOrderDetail.SalePrice = salePrice;
saleOrderDetail.RowVersion = rowVersion;
return saleOrderDetail;
}
public async Task <JsonResult> GetFullParam([FromBody] getFullParamViewModel ListFullParam)
{
var i = 0;
CM_Customer CurrentCustomer = new CM_Customer()
{
CustomerName = ListFullParam.Customer.Name,
CustomerPhone = ListFullParam.Customer.Phone,
CMND = ListFullParam.Customer.CMND,
TypeCustomerEnum = Common.Enum.SM.TypeCustomerEnum.KVL
};
#region validateSaleOrder
SaleOrder CurrentSaleOrder = new SaleOrder()
{
ReceiveAddress = ListFullParam.saleOrder.ReceiveAddress,
TotalPrice = ListFullParam.saleOrder.TotalPrice,
PaymentMethod = (Common.Enum.SM.PaymentMethod)ListFullParam.saleOrder.PaymentMethod,
DistrictID = ListFullParam.saleOrder.DistrictID,
TransportPriceID = ListFullParam.saleOrder.TransportTypeID,
};
CurrentSaleOrder.TransportTypePrice = await GetTransportPrice(ListFullParam.saleOrder.TransportPriceID, ListFullParam.saleOrder.TransportTypeID);
if (CurrentSaleOrder.TransportTypePrice == -1)
{
return(Json(new ResponseMessage {
Message = "Vui long chon nha van chuyen ", IsSuccess = false
}));
}
#endregion
List <SaleOrderDetail> CurrentSaleDetails = new List <SaleOrderDetail>();
foreach (var item in ListFullParam.saleOrderDetails)
{
var productDetails = await ProductDetailsBLL.Find(item.ProductDetailIDSale);
SaleOrderDetail temp = new SaleOrderDetail()
{
ProductDetailId = item.ProductDetailIDSale,
Quality = item.QuantitySale,
ProductDetail = productDetails
};
CurrentSaleDetails.Add(temp);
}
var isSuccess = await SaleOrderBLL.CreateBill(CurrentCustomer, CurrentSaleOrder, CurrentSaleDetails);
string BaseUrl = string.Format("{0}://{1}", HttpContext.Request.Scheme, HttpContext.Request.Host);
if (isSuccess)
{
if (CurrentSaleOrder.PaymentMethod == Common.Enum.SM.PaymentMethod.Paypal)
{
string SuccessUrl = BaseUrl + Url.Action("ExcutePayment", "Bill");
string ErrorUrl = BaseUrl + Url.Action("ErrorBill", "Bill");
var payment = await this._paypalServicesGatewayBLL.CreatePayment(SuccessUrl, ErrorUrl, CurrentSaleOrder, CurrentSaleDetails, CurrentCustomer);
CurrentSaleOrder.AuthenticationMethodGuid = payment.Id;
await this.SaleOrderBLL.Update(CurrentSaleOrder);
return(Json(new ResponseMessage {
Message = SaleOrderBLL.Message, IsSuccess = isSuccess, errorSaleOrder = SaleOrderBLL.enumErrorSaleOrder, RedirectoURl = payment.Links[1].Href
}));
}
else if (CurrentSaleOrder.PaymentMethod == Common.Enum.SM.PaymentMethod.GDTT)
{
string SuccessUrl = BaseUrl + Url.Action("PaymentTTTN", "Bill");
string ErrorUrl = BaseUrl + Url.Action("ErrorBill", "Bill");
return(Json(new ResponseMessage {
Message = SaleOrderBLL.Message, IsSuccess = isSuccess, errorSaleOrder = SaleOrderBLL.enumErrorSaleOrder, RedirectoURl = SuccessUrl
}));
}
else if (CurrentSaleOrder.PaymentMethod == Common.Enum.SM.PaymentMethod.NganLuong)
{
var ReturnUrlNganLuong = BaseUrl + Url.Action("PaymentTTTN", "Bill");
string Note = "WEB BMT";
string UrlNLRedirecto = "https://www.nganluong.vn/[email protected]&product_name=" + CurrentSaleOrder.ID + "&price=" + CurrentSaleOrder.TotalPrice + "&return_url=" + ReturnUrlNganLuong + "&comments=" + Note;
return(Json(new ResponseMessage {
Message = SaleOrderBLL.Message, IsSuccess = isSuccess, errorSaleOrder = SaleOrderBLL.enumErrorSaleOrder, RedirectoURl = UrlNLRedirecto
}));
}
return(Json(new ResponseMessage {
Message = SaleOrderBLL.Message, IsSuccess = isSuccess, errorSaleOrder = SaleOrderBLL.enumErrorSaleOrder
}));
}
else
{
return(Json(new ResponseMessage {
Message = SaleOrderBLL.Message, IsSuccess = isSuccess, errorSaleOrder = SaleOrderBLL.enumErrorSaleOrder
}));
}
}
public void PlaceSaleOrder()
{
try
{
if (rptrData.Items.Count != 0 || chkIsMakingRequired.Checked)
{
using (TransactionScope scope = new TransactionScope())
{
//Sale Order
Database.SalesOrder saleOrder = new Database.SalesOrder();
saleOrder.BillNo = txtBillNo.Text;
saleOrder.ClassName = txtClass.Text;
saleOrder.CreatedBy = currentUserName;
saleOrder.CreatedDate = DateTime.Now;
saleOrder.CustomerID = Convert.ToInt32(txtCustomerID.Text);
saleOrder.CustomerTypeID = Convert.ToInt32(ddlCustomerType.SelectedValue);
saleOrder.IsActive = true;
saleOrder.IsCompleted = chkIsComplete.Checked;
saleOrder.IsMakingRequired = chkIsMakingRequired.Checked;
saleOrder.PaidAmount = txtPaidAmount.Text == "" ? 0 : Convert.ToDecimal(txtPaidAmount.Text);
//Profit is set at the end of all items
//saleOrder.Profit=
saleOrder.Remarks = txtRemarks.Text;
saleOrder.SaleOrderDate = Convert.ToDateTime(txtSellingDate.Text);
saleOrder.TotalCost = txtTotalOrderAmount.Text == "" ? 0 : Convert.ToDecimal(txtTotalOrderAmount.Text);
//Below due to total cost above set
saleOrder.RemainingAmount = saleOrder.TotalCost - saleOrder.PaidAmount;
context.SalesOrders.Add(saleOrder);
context.SaveChanges();
if (chkIsMakingRequired.Checked)
{
//Developement work detail
DevelopmentWork dwork = new DevelopmentWork();
dwork.BillNo = saleOrder.BillNo;
dwork.BottomMeasurement = txtBottomMeasurement.Text;
if (txtConfirmDate.Text != "")
{
dwork.ConfirmDate = Convert.ToDateTime(txtConfirmDate.Text);
}
dwork.CreatedBy = currentUserName;
dwork.CreatedDate = DateTime.Now;
if (txtDeliveryDate.Text != "")
{
dwork.DeliveryDate = Convert.ToDateTime(txtDeliveryDate.Text);
}
if (fileuploadDesign.FileName != "")
{
string fileNamePath = ConfigurationManager.AppSettings[Constants.ConfigDesignPhotoPath] + "\\" + fileuploadDesign.FileName;
fileuploadDesign.SaveAs(fileNamePath);
dwork.DesignPhotoUrl = ConfigurationManager.AppSettings[Constants.ConfigDesignPhotoURL] + "\\" + fileuploadDesign.FileName;
}
dwork.InventoryTypeID = Convert.ToInt32(txtMakingInventoryType.Text);
dwork.IsActive = true;
dwork.MakingCost = txtMakingCost.Text == "" ? 0 : Convert.ToDecimal(txtMakingCost.Text);
dwork.SaleOrderID = saleOrder.SaleOrderID;
dwork.TopMeasurement = txtTopMeasurement.Text;
dwork.WorkTypeID = Convert.ToInt32(ddlWorkType.SelectedValue);
context.DevelopmentWorks.Add(dwork);
context.SaveChanges();
}
decimal?profit = 0;
List <rptrClass> printLst = new List <rptrClass>();
if (rptrData.Items.Count > 0)
{
foreach (RepeaterItem rptrItem in rptrData.Items)
{
if (rptrItem.Visible)
{
SaleOrderDetail saleOrderDetail = new SaleOrderDetail();
saleOrderDetail.CreatedBy = currentUserName;
saleOrderDetail.CreatedDate = DateTime.Now;
saleOrderDetail.InventoryTypeID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnItemID")).Value);
saleOrderDetail.IsActive = true;
saleOrderDetail.Quantity = Convert.ToInt32(((Label)rptrItem.FindControl("lblQuantity")).Text);
saleOrderDetail.SaleOrderID = saleOrder.SaleOrderID;
saleOrderDetail.SellingRate = Convert.ToDecimal(((Label)rptrItem.FindControl("lblSellingRate")).Text);
saleOrderDetail.TotalAmount = Convert.ToDecimal(((Label)rptrItem.FindControl("lblTotalAmount")).Text);
saleOrderDetail.VAT = ((Label)rptrItem.FindControl("lblVat")).Text;
context.SaleOrderDetails.Add(saleOrderDetail);
context.SaveChanges();
Database.InventoryType currentInventory = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == saleOrderDetail.InventoryTypeID).SingleOrDefault();
if (currentInventory != null)
{
var invCount = currentInventory.InventoryCount == null ? 0 : currentInventory.InventoryCount;
currentInventory.InventoryCount = invCount - saleOrderDetail.Quantity;
decimal?pRate = currentInventory.PurchaseRate == null ? 0 : currentInventory.PurchaseRate;
decimal?sRate = saleOrderDetail.SellingRate == null ? 0 : saleOrderDetail.SellingRate;
profit = profit + (sRate - pRate);
context.SaveChanges();
}
rptrClass obj = new rptrClass();
obj.ItemName = ((Label)rptrItem.FindControl("lblItemName")).Text;
obj.Quantity = Convert.ToString(saleOrderDetail.Quantity);
obj.SellingRate = Convert.ToString(saleOrderDetail.SellingRate);
obj.TotalAmount = Convert.ToString(saleOrderDetail.TotalAmount);
obj.VAT = saleOrderDetail.VAT;
printLst.Add(obj);
}
}
}
saleOrder.Profit = profit;
context.SaveChanges();
lblMessage.Text = "Record Inserted sucessfully with BILL NO " + saleOrder.BillNo;
lblMessage.ForeColor = Color.Green;
CreatePrintDiv(saleOrder.BillNo, txtAutoCustomerName.Text, saleOrder.TotalCost, printLst);
ClearForm();
txtSellingDate.Text = DateTime.Now.ToString(Constants.DateFormatDatePicker);
//BindInvRatePrevBalance();
scope.Complete();
}
}
else
{
lblMessage.Text = "Atleast One Record Should be inserted ";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
public Task <bool> Update(SaleOrderDetail entity, string UpdatedUser = "******")
{
throw new NotImplementedException();
}
