internal DataSet GetSMSOrderDetails(NewCustomerOrderBO newCustomerOrderBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(newCustomerOrderBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "Temp_OrderTransaction";
command.Parameters.Add(new SqlParameter("@shopId", newCustomerOrderBO.ShopId));
command.Parameters.Add(new SqlParameter("@Mode", newCustomerOrderBO.Mode));
command.Parameters.Add(new SqlParameter("@ProductData", newCustomerOrderBO.ProductData));
command.Parameters.Add(new SqlParameter("@QuantityData", newCustomerOrderBO.QuantityData));
command.Parameters.Add(new SqlParameter("@UnitData", newCustomerOrderBO.UnitData));
return(sqlHelper.ExecuteDataSet(command));
}
internal int UpdateNewCustomerOrder(NewCustomerOrderBO orderBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(orderBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "Temp_OrderTransaction";
sqlHelper.AddParameter(command, "@Mode", orderBO.Mode, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@UserId", orderBO.UserId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ShopID", orderBO.ShopId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ProductData", orderBO.ProductData, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@QuantityData", orderBO.QuantityData, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@UnitData", orderBO.UnitData, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@Rate", orderBO.Rate, ParameterDirection.Input);
if (orderBO.Mode == "1")
{
sqlHelper.AddParameter(command, "@SpecialInstnSet", orderBO.SpecialInstnSet, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@SiteAddress", orderBO.SiteAddress, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ContactPerson", orderBO.ContactPerson, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@Phone", orderBO.Phone, ParameterDirection.Input);
}
if (orderBO.orderDiscountIds != null && orderBO.orderDiscountIds != string.Empty && orderBO.orderDiscountIds != "")
{
sqlHelper.AddParameter(command, "@orderDiscountIds", orderBO.orderDiscountIds, ParameterDirection.Input);
}
if (orderBO.orderDiscountVals != null && orderBO.orderDiscountVals != string.Empty && orderBO.orderDiscountVals != "")
{
sqlHelper.AddParameter(command, "@OrderDiscountValues", orderBO.orderDiscountVals, ParameterDirection.Input);
}
sqlHelper.AddParameter(command, "@SchemeId", orderBO.SchemeId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@OtherInstn", orderBO.OtherInstn, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@Priority", orderBO.Priority, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@FstDisc", orderBO.FirstDiscount, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@secndDisc", orderBO.SecondDiscount, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@AmountSet", orderBO.TotalAmount, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@StockSet", orderBO.OutletStock, ParameterDirection.Input);
if (orderBO.orderDisc != null && orderBO.orderDisc != string.Empty && orderBO.orderDisc != "")
{
sqlHelper.AddParameter(command, "@OrderDisc", orderBO.orderDisc, ParameterDirection.Input);
}
if (orderBO.mobileReferenceNo != null && orderBO.mobileReferenceNo != string.Empty && orderBO.mobileReferenceNo != "")
{
sqlHelper.AddParameter(command, "@MobileReferenceNo", orderBO.mobileReferenceNo, ParameterDirection.Input);
}
if (orderBO.deliveryDate != null && orderBO.deliveryDate != string.Empty && orderBO.deliveryDate != "")
{
sqlHelper.AddParameter(command, "@DeliveryDate", orderBO.deliveryDate, ParameterDirection.Input);
}
if (orderBO.distributorId > 0)
{
sqlHelper.AddParameter(command, "@DistributorIdFromMobile", orderBO.distributorId, ParameterDirection.Input);
}
if (orderBO.paymentMode > 0)
{
sqlHelper.AddParameter(command, "@PaymentMode", orderBO.paymentMode, ParameterDirection.Input);
}
if (orderBO.ReceiptNumber != null && orderBO.ReceiptNumber != string.Empty && orderBO.ReceiptNumber != "")
{
sqlHelper.AddParameter(command, "@ReceiptNumber", orderBO.ReceiptNumber, ParameterDirection.Input);
}
if (orderBO.Mode == "2")
{
if (orderBO.MobileSyncDate != null && orderBO.MobileSyncDate != string.Empty && orderBO.MobileSyncDate != "")
{
sqlHelper.AddParameter(command, "@MobileSyncDate", orderBO.MobileSyncDate, ParameterDirection.Input);
}
if (orderBO.OrderDate != null && orderBO.OrderDate != string.Empty && orderBO.OrderDate != "")
{
sqlHelper.AddParameter(command, "@OrderDate", orderBO.OrderDate, ParameterDirection.Input);
}
}
if (orderBO.FreeQuantity != null && orderBO.FreeQuantity != string.Empty && orderBO.FreeQuantity != "")
{
sqlHelper.AddParameter(command, "@FreeQuantity", orderBO.FreeQuantity, ParameterDirection.Input);
}
if (orderBO.UnitDiscount != null && orderBO.UnitDiscount != string.Empty && orderBO.UnitDiscount != "")
{
sqlHelper.AddParameter(command, "@UnitDiscount", orderBO.UnitDiscount, ParameterDirection.Input);
}
if (orderBO.MobileDiscountFlag != null && orderBO.MobileDiscountFlag != string.Empty && orderBO.MobileDiscountFlag != "")
{
sqlHelper.AddParameter(command, "@MobileDiscountFlag", orderBO.MobileDiscountFlag, ParameterDirection.Input);
}
if (orderBO.TotalDiscount != null && orderBO.TotalDiscount != string.Empty && orderBO.TotalDiscount != "")
{
sqlHelper.AddParameter(command, "@TotalDiscountData", orderBO.TotalDiscount, ParameterDirection.Input);
}
if (orderBO.TaxAmount != null && orderBO.TaxAmount != string.Empty && orderBO.TaxAmount != "")
{
sqlHelper.AddParameter(command, "@TaxAmountData", orderBO.TaxAmount, ParameterDirection.Input);
}
return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command)));
}
