public async Task TestGetOrdersAsync()
{
// Arrange
var logger = LogHelper.GetLogger <SalesController>();
var salesService = ServiceMocker.GetSalesService(nameof(TestGetOrdersAsync));
var controller = new SalesController(logger, salesService);
// Act
var response = await controller.GetOrdersAsync() as ObjectResult;
var value = response.Value as IPagedResponse <OrderInfo>;
controller.Dispose();
// Assert
Assert.False(value.DidError);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.IsAuthenticated)
{
string currentUser = User.Identity.Name;
SalesController custmgr = new SalesController();
custmgr.AddOnlineCustomer(currentUser);
DisplayCurrentCartQty();
CurrentLoggedInUser.Text = User.Identity.Name;
if (!Page.IsPostBack)
{
var loggedInGridview = (GridView)ProductsLoggedIn.FindControl("ProductsListViewLoggedIn");
loggedInGridview.DataBind();
}
}
}
protected void AddToCartBtn_Click(object sender, EventArgs e)
{
LinkButton linkBtn = (LinkButton)sender;
string username = User.Identity.Name;
GridViewRow grdrow = (GridViewRow)((LinkButton)sender).NamingContainer;
int productid = int.Parse(linkBtn.CommandArgument.ToString());
int quantity = int.Parse((grdrow.Cells[2].FindControl("AddQtyValue") as TextBox).Text);
MessageUserControl.TryRun(() =>
{
SalesController sysmgr = new SalesController();
sysmgr.AddProductToCart(username, productid, quantity);
var loggedInGridview = (GridView)ProductsLoggedIn.FindControl("ProductsListViewLoggedIn");
loggedInGridview.DataBind();
DisplayCurrentCartQty();
}, "Added Product", "Product added to shopping cart!");
}
protected void PlaceOrderButton_Click(object sender, EventArgs e)
{
MessageUserControl.TryRun(() => {
var controller = new SalesController();
var paymentType = paymentRadioButton.SelectedValue;
var coupon = controller.GetCoupon(CouponTextBox.Text);
if (coupon != null)
{
controller.PlaceOrder(User.Identity.Name, paymentType, coupon.CouponID);
}
else
{
controller.PlaceOrder(User.Identity.Name, paymentType, 0);
}
}, "Place Order", "You place a order, thank you for shopping");
}
public async Task TestGetOrdersAsync()
{
// Arrange
var userInfo = IdentityMocker.GetCustomerIdentity().GetUserInfo();
var service = ServiceMocker.GetSalesService(userInfo, nameof(TestGetOrdersAsync));
var controller = new SalesController(LoggingHelper.GetLogger <SalesController>(), service);
// Act
var response = await controller.GetOrdersAsync() as ObjectResult;
var value = response.Value as IPagedResponse <OrderInfo>;
service.Dispose();
// Assert
Assert.False(value.DidError);
}
public async Task TestGetOrderNotFoundAsync()
{
using (var repository = RepositoryMocker.GetSalesRepository())
{
// Arrange
var controller = new SalesController(repository);
var id = 0;
// Act
var response = await controller.GetOrder(id) as ObjectResult;
// Assert
var value = response.Value as ISingleResponse <OrderHeaderViewModel>;
Assert.False(value.DidError);
}
}
public async Task TestGetOrdersSearchingBySalesOrderNumberAsync()
{
using (var repository = RepositoryMocker.GetSalesRepository())
{
// Arrange
var controller = new SalesController(repository);
var salesOrderNumber = "so72";
// Act
var response = await controller.GetOrders(salesOrderNumber : salesOrderNumber) as ObjectResult;
// Assert
var value = response.Value as IListResponse <OrderSummaryViewModel>;
Assert.False(value.DidError);
}
}
public async Task TestGetOrdersSearchingByCustomerNameAsync()
{
using (var repository = RepositoryMocker.GetSalesRepository())
{
// Arrange
var controller = new SalesController(repository);
var customerName = "her";
// Act
var response = await controller.GetOrders(customerName : customerName) as ObjectResult;
// Assert
var value = response.Value as IListResponse <OrderSummaryViewModel>;
Assert.False(value.DidError);
}
}
protected void AvailableProducts_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList dropDown = (DropDownList)sender;
// container is current row of Listview,
// which holds the dropdownlist that caused postback
if (dropDown.SelectedIndex > 0)
{
var controller = new SalesController();
var product = controller.GetProduct(int.Parse(dropDown.SelectedValue));
ResetInsertItemDefaultValues(dropDown, 1, product.UnitPrice, 0);
}
else
{
ResetInsertItemDefaultValues(dropDown, 0, 0, 0);
}
}
public async Task TestGetOrdersAsync()
{
using (var repository = RepositoryMocker.GetSalesRepository())
{
// Arrange
var controller = new SalesController(repository);
// Act
var response = await controller.GetOrders() as ObjectResult;
// Assert
var value = response.Value as IListResponse <OrderSummaryViewModel>;
Assert.False(value.DidError);
Assert.True(value.Model.Count() > 0);
}
}
protected void CustomerOrderHistoryGridView_SelectedIndexChanged(object sender, EventArgs e)
{
// if selected
if (CustomerOrderHistoryGridView.SelectedIndex >= 0)
{
// disable the NewOrder button
// prepare the OrderItemsListView
int orderId = int.Parse(CustomerOrderHistoryGridView.SelectedValue.ToString());
var controller = new SalesController();
var order = controller.GetExistingOrder(orderId);
SetupEditOrderForm(order);
// if order is shipped
// disable the OrderItemsListView
}
// else
// enable the NewOrder button
}
protected void Refresh_Click(object sender, EventArgs e)
{
MessageUserControl.TryRun(() => {
var controller = new SalesController();
var coupon = controller.GetCoupon(CouponTextBox.Text);
if (coupon == null)
{
Discount.Text = "$0.00";
Total.Text = SubTotal.Text;
throw new Exception("This coupon doesn't exist. Try again.");
}
else
{
Discount.Text = (coupon.CouponDiscount / 100.0 * double.Parse(SubTotal.Text.Substring(1))).ToString("C");
Total.Text = (double.Parse(SubTotal.Text.Substring(1)) - double.Parse(Discount.Text.Substring(1))).ToString("C");
}
}, "Refresh", "updated discount");
}
public async Task GetCreateOrderViewModelTestAsync()
{
// Arrange
var humanResourcesBusinessObject = BusinessObjectMocker.GetHumanResourcesBusinessObject();
var productionBusinessObject = BusinessObjectMocker.GetProductionBusinessObject();
var salesBusinessObject = BusinessObjectMocker.GetSalesBusinessObject();
using (var controller = new SalesController(null, humanResourcesBusinessObject, productionBusinessObject, salesBusinessObject))
{
// Act
var response = await controller.GetCreateOrderViewModel() as ObjectResult;
// Assert
var value = response.Value as ISingleModelResponse <CreateOrderViewModel>;
Assert.False(value.DidError);
}
}
protected void RefundButton_Click(object sender, EventArgs e)
{
SalesController sc = new SalesController();
MessageUserControl.TryRun(() =>
{
RefundInvoiceTextBoxDisplay.Text = sc.Do_RefundTransaction(DumpGridView()).ToString();
}, "Success", "Refund Completed");
TextBox textBox = new TextBox();
foreach (GridViewRow row in InvoiceGridView.Rows)
{
textBox = (TextBox)row.FindControl("Reason");
textBox.ReadOnly = true;
}
RefundButton.Enabled = false;
}
public void AddStock()
{
ISalesController userController = new SalesController();
Stock stock = new Stock()
{
Item_Id = 1,
UnitPrice = 10,
TotalPrice = 20,
Quantity = 2,
CreatedAt = DateTime.Now,
CompanyName = "Lojitech",
EntityState = EntityState.Added
};
userController.ManageStock(stock, stock.EntityState);
Assert.AreNotEqual(null, userController.GetItems(true).FirstOrDefault(x => x.Id.Equals(stock.Item_Id)).Stocks.FirstOrDefault(x => x.Id.Equals(stock.Id)));
userController.ManageStock(stock, EntityState.Deleted);
}
public async Task TestGetCreateOrderRequestAsync()
{
// Arrange
var logger = LoggerMocker.GetLogger <SalesController>();
var salesService = ServiceMocker.GetSalesService();
using (var controller = new SalesController(logger, salesService))
{
// Act
var response = await controller.GetCreateOrderRequestAsync() as ObjectResult;
var value = response.Value as ISingleResponse <CreateOrderRequest>;
// Assert
Assert.False(value.DidError);
Assert.True(value.Model.Products.Count() >= 0);
}
}
public async Task TestCloneOrderAsync()
{
// Arrange
var logger = LoggingHelper.GetLogger <SalesController>();
var service = ServiceMocker.GetSalesService(nameof(TestCloneOrderAsync));
var controller = new SalesController(logger, service);
var id = 1;
// Act
var response = await controller.CloneOrderAsync(id) as ObjectResult;
var value = response.Value as ISingleResponse <OrderHeader>;
service.Dispose();
// Assert
Assert.False(value.DidError);
}
protected void DeleteItemBtn_Click(object sender, EventArgs e)
{
LinkButton cmdBtn = (LinkButton)sender;
int shoppingcartitemid = int.Parse(cmdBtn.CommandArgument);
MessageUserControl.TryRun(() =>
{
SalesController sysmgr = new SalesController();
sysmgr.DeleteItem(User.Identity.Name, shoppingcartitemid);
ShoppingCartListView.DataBind();
ShoppingCartTotal();
DisplayCurrentCartQty();
if (!CheckForItemsInCart())
{
checkoutButton.HRef = "~/Sales/PartsCatalog.aspx";
}
}, "Removal Successful", "Item has been removed from your cart.");
}
public void UpdateSale_WithInvalidModel_Returns_BadRequestResult()
{
// Arrange
var mediatorMock = new Mock <IMediator>();
var loggerMock = new Mock <ILogger <SalesController> >();
var salesServiceMock = new Mock <ISaleStatisticService>();
var controller = new SalesController(loggerMock.Object, mediatorMock.Object, salesServiceMock.Object);
controller.ModelState.AddModelError("Error", "Model Error");
var saleDTO = new SaleDTO();
// Act
var result = controller.UpdateSale(saleDTO).GetAwaiter().GetResult();
// Assert
Assert.IsType <BadRequestObjectResult>(result);
}
public async Task TestGetOrderAsync()
{
// Arrange
var logger = LoggerMocker.GetLogger <SalesController>();
var salesService = ServiceMocker.GetSalesService();
var id = 1;
using (var controller = new SalesController(logger, salesService))
{
// Act
var response = await controller.GetOrderAsync(id) as ObjectResult;
var value = response.Value as ISingleResponse <Order>;
// Assert
Assert.False(value.DidError);
}
}
public void SendToGarbageFromStock()
{
ISalesController userController = new SalesController();
IList <Stock> Stocks = userController.GetItems(true).FirstOrDefault(x => x.Id.Equals(1)).Stocks.ToList();
int quantity;
if (Stocks != null && Stocks.Count > 0)
{
Stock stock = Stocks.ElementAt(0);
quantity = Convert.ToInt32(stock.Quantity);
userController.AddGarbage(stock, 1);
Assert.AreEqual(quantity - 1, stock.Quantity);
}
else
{
Assert.Fail("Null exception");
}
}
public void Sale()
{
SaleCreateDto sale = new SaleCreateDto();
saleController = new SalesController();
productController = new ProductsController();
Console.Write("\nUsuario id: ");
sale.UserId = int.Parse(Console.ReadLine());
Console.Write("\nCliente id: ");
sale.ClientId = int.Parse(Console.ReadLine());
Console.Write("\nEs Venta Fiada ?? S | N ");
sale.Trusted = Console.ReadLine() == "S" ? true : false;
SaleItemCreateDto item;
bool @continue = true;
while (@continue)
{
item = new SaleItemCreateDto();
Console.Write("\n\nProduct Id: ");
item.ProductId = int.Parse(Console.ReadLine());
Products product = (Products)productController.Consult(item.ProductId);
if (product != null)
{
Console.Write("\nCantidad: ");
item.Quantity = int.Parse(Console.ReadLine());
sale.ProductList.Add(item);
sale.Total += product.Price;
}
else
{
Console.Write("\n\n\tProducto no encontrado");
}
Console.Write("\n\nAgregar otro producto ?? S | N ");
@continue = Console.ReadLine() == "S" ? true : false;
}
if (saleController.DoSale(sale))
{
Console.WriteLine("\nVenta registrada satisfactoriamente");
}
}
public async Task TestGetOrdersByEmployeeAsync()
{
// Arrange
var logger = LoggerMocker.GetLogger <SalesController>();
var salesService = ServiceMocker.GetSalesService();
var employeeID = 1;
using (var controller = new SalesController(logger, salesService))
{
// Act
var response = await controller.GetOrdersAsync(employeeID : employeeID) as ObjectResult;
var value = response.Value as IPagedResponse <OrderInfo>;
// Assert
Assert.False(value.DidError);
Assert.True(value.Model.Where(item => item.EmployeeID == employeeID).Count() == value.Model.Count());
}
}
public void SendToGarbageFromBorrow()
{
ISalesController userController = new SalesController();
User user = userController.GetAllUsers(true).FirstOrDefault(x => x.Id.Equals(1));
IList <Borrow> Borrows = user.Borrows.ToList();
int quantity;
if (Borrows != null && Borrows.Count > 0)
{
Borrow borrow = Borrows.ElementAt(0);
quantity = Convert.ToInt32(borrow.Quantity);
userController.AddGarbage(borrow, 1);
Assert.AreEqual(quantity - 1, borrow.Quantity);
}
else
{
Assert.Fail("Null exception");
}
}
public async Task TestGetOrdersByCustomerAsync()
{
// Arrange
var logger = LoggingHelper.GetLogger <SalesController>();
var service = ServiceMocker.GetSalesService(nameof(TestGetOrdersByCustomerAsync));
var controller = new SalesController(logger, service);
var customerID = 1;
// Act
var response = await controller.GetOrdersAsync(customerID : customerID) as ObjectResult;
var value = response.Value as IPagedResponse <OrderInfo>;
service.Dispose();
// Assert
Assert.False(value.DidError);
Assert.True(value.Model.Count(item => item.CustomerID == customerID) == value.Model.Count());
}
public void GetSalesStatistic_WithMissingQueryParameter_Returns_BadRequestResult()
{
// Arrange
var mediatorMock = new Mock <IMediator>();
var loggerMock = new Mock <ILogger <SalesController> >();
var salesServiceMock = new Mock <ISaleStatisticService>();
var controller = new SalesController(loggerMock.Object, mediatorMock.Object, salesServiceMock.Object);
var scale = TimeUnit.Quarter;
var startDate = DateTime.Parse("2019-01-01");
// Act
var result = controller.GetSalesStatistic(scale, startDate, null).GetAwaiter().GetResult();
// Assert
var badRequestObjectResult = Assert.IsType <BadRequestObjectResult>(result);
Assert.IsAssignableFrom <string>(badRequestObjectResult.Value);
}
public void Controller_Remove_Order_No_Error()
{
// Arrange
var salesController = new SalesController(mockSalesService.Object);
var eid = 77;
var rid = -1;
mockSalesService.Setup(nt => nt.Remove(eid)).Callback <Int32>(x => {
rid = x;
});
// Action
var ar = salesController.Delete(eid);
// Assert
mockSalesService.Verify(x => x.Remove(eid), Times.Once);
Assert.AreEqual(eid, rid);
Assert.IsInstanceOfType(ar, typeof(OkResult));
}
public async Task TestGetCreateOrderRequestAsync()
{
// Arrange
var userInfo = IdentityMocker.GetCustomerIdentity().GetUserInfo();
var service = ServiceMocker.GetSalesService(userInfo, nameof(TestGetCreateOrderRequestAsync));
var controller = new SalesController(LoggingHelper.GetLogger <SalesController>(), service);
// Act
var response = await controller.GetCreateOrderRequestAsync() as ObjectResult;
var value = response.Value as ISingleResponse <Core.BusinessLayer.Requests.CreateOrderRequest>;
service.Dispose();
// Assert
Assert.False(value.DidError);
Assert.True(value.Model.Products.Count() > 0);
Assert.True(value.Model.Customers.Count() > 0);
}
public async Task TestGetCreateOrderRequestAsync()
{
// Arrange
var logger = LoggerMocker.GetLogger <SalesController>();
var humanResourcesBusinessObject = BusinessObjectMocker.GetHumanResourcesBusinessObject();
var productionBusinessObject = BusinessObjectMocker.GetProductionBusinessObject();
var salesBusinessObject = BusinessObjectMocker.GetSalesBusinessObject();
using (var controller = new SalesController(logger, humanResourcesBusinessObject, productionBusinessObject, salesBusinessObject))
{
// Act
var response = await controller.GetCreateOrderRequestAsync() as ObjectResult;
var value = response.Value as ISingleResponse <CreateOrderRequest>;
// Assert
Assert.False(value.DidError);
}
}
protected void UpdateQty_Click(object sender, EventArgs e)
{
LinkButton cmdBtn = (LinkButton)sender;
string direction = cmdBtn.CommandArgument.ToString();
int partid = int.Parse((cmdBtn.Parent.FindControl("ProductIdLabel") as Label).Text);
MessageUserControl.TryRun(() =>
{
SalesController sysmgr = new SalesController();
sysmgr.UpdateItem(User.Identity.Name, partid, direction);
ShoppingCartListView.DataBind();
ShoppingCartTotal();
DisplayCurrentCartQty();
if (!CheckForItemsInCart())
{
checkoutButton.HRef = "~/Sales/PartsCatalog.aspx";
}
}, "Quantity Updated", "Part Quantity has been updated");
}
/***********************************Function to Get Sales File into DataTable***********************************/
public string getSales()
{
SalesController objSalesController = new SalesController();
string lblMessage = "";
string strPath = Server.MapPath("~/") + "UploadFile\\Sales.xls";
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strPath;
excelConnectionString += @";Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""";
OleDbConnection connection = new OleDbConnection(excelConnectionString);
string Name = "";
try
{
connection.Open();
DataTable SheetName = new DataTable();
SheetName = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string[] excelSheets = new string[SheetName.Rows.Count];
int i = 0;
// Add the sheet name to the string array.
foreach (DataRow row in SheetName.Rows)
{
excelSheets[i] = SheetName.Rows[0]["TABLE_NAME"].ToString();
Name = excelSheets[i];
}
DataTable dtNew = new DataTable();
string query = "Select * FROM [" + Name + "]";
OleDbCommand command = new OleDbCommand(query, connection);
OleDbDataAdapter dataread = new OleDbDataAdapter(command);
DataTable dt = new DataTable();
dataread.Fill(dt);
dtNew = dt;
lblMessage = SaveSales(dtNew);
//lblMessage = "File Sales saved successfully";
connection.Close();
return lblMessage;
}
catch (Exception ex)
{
connection.Close();
string strMessage = ex.Message.ToString();
if (strMessage == "External table is not in the expected format." || strMessage.Contains("does not belong to table"))
{
lblMessage = "Excel file is not in valid format";
}
else
{
lblMessage = "File Sales could not be saved successfully";
}
return lblMessage;
}
}
/***********************************Function to Save Sales File into Sql Server 2000 using Bulk Copy Method***********************************/
public string SaveSales(DataTable dt)
{
string lblMessage = "";
SalesController objCont = new SalesController();
string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();
//try
//{
// string strDelete = "Delete from SalesTemp";
// objController.ExecuteQuery(strDelete);
// SqlConnection sqlconn = new SqlConnection(sConnectionString);
// sqlconn.Open();
// SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn);
// bulkCopy.DestinationTableName = "SalesTemp";
// bulkCopy.WriteToServer(dt);
//}
//catch
//{
//}
DataTable dtMonthOC = new DataTable();
string strMonthOCQuery = "select * from MonthOpenClose";
dtMonthOC = objController.ExecuteQuery(strMonthOCQuery);
DataView dvMonthOC = new DataView(dtMonthOC);
DataTable dtFilter = new DataTable();
string[] strFromSalesMonth = txtSalesFromDate.Text.Trim().Split('/');
int FromMonth = Convert.ToInt16(strFromSalesMonth[1]);
//int FromMonth = CalSalesfromDate.SelectedDate.Month;
dvMonthOC.RowFilter = "MonthID =" + FromMonth;
dtFilter = dvMonthOC.ToTable();
if (dtFilter.Rows != null)
{
bool OCStatus = Convert.ToBoolean(dtFilter.Rows[0]["Status"]);
if (OCStatus == false)
{
lblMessage = "Month is Closed, Please open month to enter data";
}
else
{
string[] strToSalesDate = txtSalesToDate.Text.Trim().Split('/');
//int ToMonth = CalSalestoDate.SelectedDate.Month;
int ToMonth = Convert.ToInt16(strToSalesDate[1]);
int rcount = 0;
foreach (DataRow dr in dt.Rows)
{
int IsModelEx = 1;
SalesUI objUI = new SalesUI();
try
{
objUI.Sno = Convert.ToInt32(dr["Sno"]);
if (dr["Inv#No"].ToString() == "7253102")
{
string strTest = "";
}
objUI.InvoiceNo = Convert.ToInt32(dr["Inv#No"]);
//objUI.Date = Convert.ToString(dr["Date"]);
string strDate = Convert.ToString(dr["Date"]);
if (strDate == "" || strDate == "00.00.0000")
{
objUI.Date = Convert.ToDateTime("1/1/2001");
}
else
{
objUI.Date = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["Date"])));
}
objUI.Dealer_Code = Convert.ToString(dr["DlrCode"]);
objUI.Dealer_Name = Convert.ToString(dr["Dlr Name"]);
objUI.Blank = Convert.ToString(dr["F10"]);
string strMaterial = dr["F10"].ToString();
string strModelQuery = "Select * from ModelMapping where Material='" + strMaterial + "'";
DataTable dtModel = objController.ExecuteQuery(strModelQuery);
if (dtModel != null)
{
if (dtModel.Rows.Count > 0)
{
foreach (DataRow drModel in dtModel.Rows)
{
objUI.ModelMappingID = Convert.ToInt32(drModel["ID"].ToString());
IsModelEx = 0;
}
}
}
objUI.Model_Code = Convert.ToString(dr["Model Code"]);
string strQuantity = Convert.ToString(dr["Qty"]);
if (strQuantity == "")
{
objUI.Quantity = Convert.ToInt32(null);
}
else
{
objUI.Quantity = Convert.ToInt32(dr["Qty"]);
}
string strSaleAmt = dr["Sale Amt"].ToString();
if (strSaleAmt == "")
{
objUI.SalesAmount = Convert.ToDouble(null);
}
else
{
objUI.SalesAmount = Convert.ToDouble(dr["Sale Amt"]);
}
string strDiscount = Convert.ToString(dr["Discount"]);
if (strDiscount == "")
{
objUI.Discount = Convert.ToInt32(null);
}
else
{
objUI.Discount = Convert.ToInt32(dr["Discount"]);
}
string strSPLDIS = Convert.ToString(dr["SPL#DIS"]);
if (strSPLDIS == "")
{
objUI.SPLDIS = Convert.ToDouble(null);
}
else
{
objUI.SPLDIS = Convert.ToDouble(dr["SPL#DIS"]);
}
string strExciseDuty = Convert.ToString(dr["Excise Duty"]);
if (strExciseDuty == "")
{
objUI.ExciseDuty = Convert.ToInt32(null);
}
else
{
objUI.ExciseDuty = Convert.ToInt32(dr["Excise Duty"]);
}
//objUI.Edu_Cess = Convert.ToInt32(dr["Edu# Cess"]);
//objUI.HR_ECess = Convert.ToInt32(dr["Hr#ECess"]);
string strEdu_Cess = Convert.ToString(dr["Edu# Cess"]);
if (strEdu_Cess == "")
{
objUI.Edu_Cess = Convert.ToInt32(null);
}
else
{
objUI.Edu_Cess = Convert.ToInt32(dr["Edu# Cess"]);
}
string strHRECess = Convert.ToString(dr["Hr#ECess"]);
if (strHRECess == "")
{
objUI.HR_ECess = Convert.ToInt32(null);
}
else
{
objUI.HR_ECess = Convert.ToInt32(dr["Hr#ECess"]);
}
string strLSPD = Convert.ToString(dr["LSPD"]);
if (strLSPD == "")
{
objUI.LSPD = Convert.ToInt32(null);
}
else
{
objUI.LSPD = Convert.ToInt32(dr["LSPD"]);
}
string strMSPSD = Convert.ToString(dr["MSPSD"]);
if (strMSPSD == "")
{
objUI.MSPSD = Convert.ToInt32(null);
}
else
{
objUI.MSPSD = Convert.ToInt32(dr["MSPSD"]);
}
string strDHC = Convert.ToString(dr["DHC"]);
if (strDHC == "")
{
objUI.DHC = Convert.ToInt32(null);
}
else
{
objUI.DHC = Convert.ToInt32(dr["DHC"]);
}
string strTaxable = Convert.ToString(dr["Taxable"]);
if (strTaxable == "")
{
objUI.Taxable = Convert.ToDouble(null);
}
else
{
objUI.Taxable = Convert.ToDouble(dr["Taxable"]);
}
string strCST = Convert.ToString(dr["CST"]);
if (strCST == "")
{
objUI.CST = Convert.ToDouble(null);
}
else
{
objUI.CST = Convert.ToDouble(dr["CST"]);
}
string strLST = Convert.ToString(dr["LST"]);
if (strLST == "")
{
objUI.LST = Convert.ToDouble(null);
}
else
{
objUI.LST = Convert.ToDouble(dr["LST"]);
}
string strSurch = Convert.ToString(dr["Surch"]);
if (strSurch == "")
{
objUI.Surch = Convert.ToInt32(null);
}
else
{
objUI.Surch = Convert.ToInt32(dr["Surch"]);
}
string strDely_Chgs = Convert.ToString(dr["Dely Chgs"]);
if (strDely_Chgs == "")
{
objUI.Dely_Chgs = Convert.ToInt32(null);
}
else
{
objUI.Dely_Chgs = Convert.ToInt32(dr["Dely Chgs"]);
}
string strEntityTot = Convert.ToString(dr["Enty/TOT"]);
if (strEntityTot == "")
{
objUI.EntityTot = Convert.ToDouble(null);
}
else
{
objUI.EntityTot = Convert.ToDouble(dr["Enty/TOT"]);
}
string strFreight = Convert.ToString(dr["Freight"]);
if (strFreight == "")
{
objUI.Freight = Convert.ToDouble(null);
}
else
{
objUI.Freight = Convert.ToDouble(dr["Freight"]);
}
string strNetAmount = Convert.ToString(dr["Net Amount"]);
if (strNetAmount == "")
{
objUI.Net_Amount = Convert.ToDouble(null);
}
else
{
objUI.Net_Amount = Convert.ToDouble(dr["Net Amount"]);
}
string strCost = Convert.ToString(dr["Cost"]);
if (strCost == "")
{
objUI.Cost = Convert.ToInt32(null);
}
else
{
objUI.Cost = Convert.ToInt32(dr["Cost"]);
}
objUI.SOff = Convert.ToString(dr["S#Off"]);
//objUI.FromDate = CalSalesfromDate.SelectedDate;
//objUI.ToDate = CalSalestoDate.SelectedDate;
objUI.FromDate = Convert.ToDateTime(objUtility.ConvertDateTime(txtSalesFromDate.Text.Trim()));
objUI.ToDate = Convert.ToDateTime(objUtility.ConvertDateTime(txtSalesToDate.Text.Trim()));
if (IsModelEx == 0)
{
objCont.SaveSales(objUI);
rcount++;
}
else
{
string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[IsApproved],[FromDate],[ToDate],IsModelEx) ";
strQuery += "Values ('" + dr["Sno"].ToString() + "','" + dr["Inv#No"].ToString() + "','" + dr["Date"].ToString() + "','" + dr["DlrCode"].ToString() + "','" + dr["Dlr Name"].ToString() + "','" + dr["F10"].ToString() + "','" + dr["Model Code"].ToString() + "','" + dr["Qty"].ToString() + "','" + dr["Sale Amt"].ToString() + "','" + dr["Discount"].ToString() + "','" + dr["SPL#DIS"].ToString() + "','" + dr["Excise Duty"].ToString() + "','" + dr["Edu# Cess"].ToString() + "','" + dr["Hr#ECess"].ToString() + "','" + dr["LSPD"].ToString() + "','" + dr["MSPSD"].ToString() + "','" + dr["DHC"].ToString() + "','" + dr["Taxable"].ToString() + "','" + dr["CST"].ToString() + "','" + dr["LST"].ToString() + "','" + dr["Surch"].ToString() + "','" + dr["Enty/TOT"].ToString() + "','" + dr["Dely Chgs"].ToString() + "','" + dr["Freight"].ToString() + "','" + dr["Net Amount"].ToString() + "','" + dr["Cost"].ToString() + "','" + dr["S#off"] + "',0,'" + objUtility.ConvertDateTime(txtSalesFromDate.Text.Trim()) + "','" + objUtility.ConvertDateTime(txtSalesToDate.Text.Trim()) + "'," + IsModelEx + ")";
objController.ExecuteQuery(strQuery);
}
lblMessage = "File Sales saved successfully;No of Rows Affected:" + rcount;
}
catch
{
lnkSalesException.Visible = true;
string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[IsApproved],[FromDate],[ToDate],IsModelEx) ";
strQuery += "Values ('" + dr["Sno"].ToString() + "','" + dr["Inv#No"].ToString() + "','" + dr["Date"].ToString() + "','" + dr["DlrCode"].ToString() + "','" + dr["Dlr Name"].ToString() + "','" + dr["F10"].ToString() + "','" + dr["Model Code"].ToString() + "','" + dr["Qty"].ToString() + "','" + dr["Sale Amt"].ToString() + "','" + dr["Discount"].ToString() + "','" + dr["SPL#DIS"].ToString() + "','" + dr["Excise Duty"].ToString() + "','" + dr["Edu# Cess"].ToString() + "','" + dr["Hr#ECess"].ToString() + "','" + dr["LSPD"].ToString() + "','" + dr["MSPSD"].ToString() + "','" + dr["DHC"].ToString() + "','" + dr["Taxable"].ToString() + "','" + dr["CST"].ToString() + "','" + dr["LST"].ToString() + "','" + dr["Surch"].ToString() + "','" + dr["Enty/TOT"].ToString() + "','" + dr["Dely Chgs"].ToString() + "','" + dr["Freight"].ToString() + "','" + dr["Net Amount"].ToString() + "','" + dr["Cost"].ToString() + "','" + dr["S#off"] + "',0,'" + objUtility.ConvertDateTime(txtSalesFromDate.Text.Trim()) + "','" + objUtility.ConvertDateTime(txtSalesToDate.Text.Trim()) + "'," + IsModelEx + ")";
objController.ExecuteQuery(strQuery);
}
}
}
}
return lblMessage;
}
public string SaveSales(DataTable dt)
{
string lblMessage = "";
SalesController objCont = new SalesController();
string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();
int rcount = 0;
foreach (DataRow dr in dt.Rows)
{
int IsModelEx = 1;
int SalesID = Convert.ToInt32(dr["ID"].ToString());
SalesUI objUI = new SalesUI();
try
{
objUI.Sno = Convert.ToInt32(dr["Sno"]);
objUI.InvoiceNo = Convert.ToInt32(dr["Inv#No"]);
string strDate = Convert.ToString(dr["Date"]);
if (strDate == "" || strDate == "00.00.0000")
{
objUI.Date = Convert.ToDateTime("1/1/2001");
}
else
{
objUI.Date = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["Date"])));
}
objUI.Dealer_Code = Convert.ToString(dr["DlrCode"]);
objUI.Dealer_Name = Convert.ToString(dr["Dlr Name"]);
objUI.Blank = Convert.ToString(dr["F10"]);
string strMaterial = dr["F10"].ToString();
string strModelQuery = "Select * from ModelMapping where Material='" + strMaterial + "'";
DataTable dtModel = objQueryController.ExecuteQuery(strModelQuery);
if (dtModel != null)
{
if (dtModel.Rows.Count > 0)
{
foreach (DataRow drModel in dtModel.Rows)
{
objUI.ModelMappingID = Convert.ToInt32(drModel["ID"].ToString());
IsModelEx = 0;
}
}
}
objUI.Model_Code = Convert.ToString(dr["Model Code"]);
objUI.Quantity = Convert.ToInt32(dr["Qty"]);
objUI.SalesAmount = Convert.ToDouble(dr["Sale Amt"]);
string strDiscount = Convert.ToString(dr["Discount"]);
if (strDiscount == "")
{
objUI.Discount = Convert.ToInt32(null);
}
else
{
objUI.Discount = Convert.ToInt32(dr["Discount"]);
}
string strSPLDIS = Convert.ToString(dr["SPL#DIS"]);
if (strSPLDIS == "")
{
objUI.SPLDIS = Convert.ToDouble(null);
}
else
{
objUI.SPLDIS = Convert.ToDouble(dr["SPL#DIS"]);
}
string strExciseDuty = Convert.ToString(dr["Excise Duty"]);
if (strExciseDuty == "")
{
objUI.ExciseDuty = Convert.ToInt32(null);
}
else
{
objUI.ExciseDuty = Convert.ToInt32(dr["Excise Duty"]);
}
objUI.Edu_Cess = Convert.ToInt32(dr["Edu# Cess"]);
objUI.HR_ECess = Convert.ToInt32(dr["Hr#ECess"]);
string strLSPD = Convert.ToString(dr["LSPD"]);
if (strLSPD == "")
{
objUI.LSPD = Convert.ToInt32(null);
}
else
{
objUI.LSPD = Convert.ToInt32(dr["LSPD"]);
}
string strMSPSD = Convert.ToString(dr["MSPSD"]);
if (strMSPSD == "")
{
objUI.MSPSD = Convert.ToInt32(null);
}
else
{
objUI.MSPSD = Convert.ToInt32(dr["MSPSD"]);
}
string strDHC = Convert.ToString(dr["DHC"]);
if (strDHC == "")
{
objUI.DHC = Convert.ToInt32(null);
}
else
{
objUI.DHC = Convert.ToInt32(dr["DHC"]);
}
string strTaxable = Convert.ToString(dr["Taxable"]);
if (strTaxable == "")
{
objUI.Taxable = Convert.ToDouble(null);
}
else
{
objUI.Taxable = Convert.ToDouble(dr["Taxable"]);
}
string strCST = Convert.ToString(dr["CST"]);
if (strCST == "")
{
objUI.CST = Convert.ToDouble(null);
}
else
{
objUI.CST = Convert.ToDouble(dr["CST"]);
}
string strLST = Convert.ToString(dr["LST"]);
if (strLST == "")
{
objUI.LST = Convert.ToDouble(null);
}
else
{
objUI.LST = Convert.ToDouble(dr["LST"]);
}
string strSurch = Convert.ToString(dr["Surch"]);
if (strSurch == "")
{
objUI.Surch = Convert.ToInt32(null);
}
else
{
objUI.Surch = Convert.ToInt32(dr["Surch"]);
}
string strDely_Chgs = Convert.ToString(dr["Dely Chgs"]);
if (strDely_Chgs == "")
{
objUI.Dely_Chgs = Convert.ToInt32(null);
}
else
{
objUI.Dely_Chgs = Convert.ToInt32(dr["Dely Chgs"]);
}
string strEntityTot = Convert.ToString(dr["Enty/TOT"]);
if (strEntityTot == "")
{
objUI.EntityTot = Convert.ToInt32(null);
}
else
{
objUI.EntityTot = Convert.ToInt32(dr["Enty/TOT"]);
}
string strFreight = Convert.ToString(dr["Freight"]);
if (strFreight == "")
{
objUI.Freight = Convert.ToDouble(null);
}
else
{
objUI.Freight = Convert.ToDouble(dr["Freight"]);
}
objUI.Net_Amount = Convert.ToDouble(dr["Net Amount"]);
objUI.Cost = Convert.ToInt32(dr["Cost"]);
objUI.SOff = Convert.ToString(dr["S#Off"]);
objUI.FromDate = Convert.ToDateTime(dr["FromDate"].ToString());
objUI.ToDate = Convert.ToDateTime(dr["ToDate"].ToString());
if (IsModelEx == 0)
{
objCont.SaveSales(objUI);
rcount++;
}
else
{
string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[IsApproved],[FromDate],[ToDate],IsModelEx) ";
strQuery += "Values ('" + dr["Sno"].ToString() + "','" + dr["Inv#No"].ToString() + "','" + dr["Date"].ToString() + "','" + dr["DlrCode"].ToString() + "','" + dr["Dlr Name"].ToString() + "','" + dr["F10"].ToString() + "','" + dr["Model Code"].ToString() + "','" + dr["Qty"].ToString() + "','" + dr["Sale Amt"].ToString() + "','" + dr["Discount"].ToString() + "','" + dr["SPL#DIS"].ToString() + "','" + dr["Excise Duty"].ToString() + "','" + dr["Edu# Cess"].ToString() + "','" + dr["Hr#ECess"].ToString() + "','" + dr["LSPD"].ToString() + "','" + dr["MSPSD"].ToString() + "','" + dr["DHC"].ToString() + "','" + dr["Taxable"].ToString() + "','" + dr["CST"].ToString() + "','" + dr["LST"].ToString() + "','" + dr["Surch"].ToString() + "','" + dr["Enty/TOT"].ToString() + "','" + dr["Dely Chgs"].ToString() + "','" + dr["Freight"].ToString() + "','" + dr["Net Amount"].ToString() + "','" + dr["Cost"].ToString() + "','" + dr["S#off"] + "',0,'" + dr["FromDate"].ToString() + "','" + dr["ToDate"].ToString() + "'," + IsModelEx + ")";
objQueryController.ExecuteQuery(strQuery);
}
lblMessage = "File Sales saved successfully;No of Rows Affected:" + rcount;
}
catch
{
string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[IsApproved],[FromDate],[ToDate],IsModelEx) ";
strQuery += "Values ('" + dr["Sno"].ToString() + "','" + dr["Inv#No"].ToString() + "','" + dr["Date"].ToString() + "','" + dr["DlrCode"].ToString() + "','" + dr["Dlr Name"].ToString() + "','" + dr["F10"].ToString() + "','" + dr["Model Code"].ToString() + "','" + dr["Qty"].ToString() + "','" + dr["Sale Amt"].ToString() + "','" + dr["Discount"].ToString() + "','" + dr["SPL#DIS"].ToString() + "','" + dr["Excise Duty"].ToString() + "','" + dr["Edu# Cess"].ToString() + "','" + dr["Hr#ECess"].ToString() + "','" + dr["LSPD"].ToString() + "','" + dr["MSPSD"].ToString() + "','" + dr["DHC"].ToString() + "','" + dr["Taxable"].ToString() + "','" + dr["CST"].ToString() + "','" + dr["LST"].ToString() + "','" + dr["Surch"].ToString() + "','" + dr["Enty/TOT"].ToString() + "','" + dr["Dely Chgs"].ToString() + "','" + dr["Freight"].ToString() + "','" + dr["Net Amount"].ToString() + "','" + dr["Cost"].ToString() + "','" + dr["S#off"] + "',0,'" + dr["FromDate"].ToString() + "','" + dr["ToDate"].ToString() + "'," + IsModelEx + ")";
objQueryController.ExecuteQuery(strQuery);
}
string strDeleteQuery = "Delete from SalesTemp where [ID]=" + SalesID;
objQueryController.ExecuteQuery(strDeleteQuery);
}
return lblMessage;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
SalesController objCont = new SalesController();
int rcount = 0;
foreach (GridViewRow gr in grdSalesException.Rows)
{
bool Discard = ((CheckBox)gr.FindControl("chkDiscard")).Checked;
string str = ((HiddenField)gr.FindControl("hdnID")).Value;
if (Discard == true)
{
string strDiscardQuery = "Delete from SalesTemp where ID=" + Convert.ToInt16(str);
objQueryController.ExecuteQuery(strDiscardQuery);
string strQuery = "Select * from SalesTemp";
DataTable dt = new DataTable();
dt = objQueryController.ExecuteQuery(strQuery);
grdSalesException.DataSource = dt;
grdSalesException.DataBind();
}
else
{
SalesUI objUI = new SalesUI();
try
{
objUI.Sno = Convert.ToInt16(((TextBox)gr.FindControl("txtSno")).Text);
objUI.InvoiceNo = Convert.ToInt32(((TextBox)gr.FindControl("txtInvoiceNo")).Text);
//objUI.Date = Convert.ToString(((TextBox)gr.FindControl("txtDate")).Text);
string strDate = Convert.ToString(((TextBox)gr.FindControl("txtDate")).Text);
if (strDate == "" || strDate == "00.00.0000")
{
objUI.Date = Convert.ToDateTime("1/1/2001");
}
else
{
objUI.Date = Convert.ToDateTime(ConvertDateTime(((TextBox)gr.FindControl("txtDate")).Text));
}
objUI.Dealer_Code = Convert.ToString(((TextBox)gr.FindControl("txtDealerCode")).Text);
objUI.Dealer_Name = Convert.ToString(((TextBox)gr.FindControl("txtDealerName")).Text);
objUI.Blank = Convert.ToString(((TextBox)gr.FindControl("txtBlank")).Text);
string strMaterial = Convert.ToString(((TextBox)gr.FindControl("txtBlank")).Text);
objUI.Model_Code = Convert.ToString(((TextBox)gr.FindControl("txtModelCode")).Text);
objUI.Quantity = Convert.ToInt16(((TextBox)gr.FindControl("txtQuantity")).Text);
objUI.SalesAmount = Convert.ToDouble(((TextBox)gr.FindControl("txtSalesAmt")).Text);
string strDiscount = Convert.ToString(((TextBox)gr.FindControl("txtDiscount")).Text);
if (strDiscount == "")
{
objUI.Discount = Convert.ToInt32(null);
}
else
{
objUI.Discount = Convert.ToInt32(((TextBox)gr.FindControl("txtDiscount")).Text);
}
string strSPLDIS = Convert.ToString(((TextBox)gr.FindControl("txtSPLDIS")).Text);
if (strSPLDIS == "")
{
objUI.SPLDIS = Convert.ToDouble(null);
}
else
{
objUI.SPLDIS = Convert.ToDouble(((TextBox)gr.FindControl("txtSPLDIS")).Text);
}
string strExciseDuty = Convert.ToString(((TextBox)gr.FindControl("txtExciseDuty")).Text);
if (strExciseDuty == "")
{
objUI.ExciseDuty = Convert.ToInt16(null);
}
else
{
objUI.ExciseDuty = Convert.ToInt16(((TextBox)gr.FindControl("txtExciseDuty")).Text);
}
objUI.Edu_Cess = Convert.ToInt16(((TextBox)gr.FindControl("txtEduCess")).Text);
objUI.HR_ECess = Convert.ToInt16(((TextBox)gr.FindControl("txtHrECess")).Text);
string strLSPD = Convert.ToString(((TextBox)gr.FindControl("txtLSPD")).Text);
if (strLSPD == "")
{
objUI.LSPD = Convert.ToInt16(null);
}
else
{
objUI.LSPD = Convert.ToInt16(((TextBox)gr.FindControl("txtLSPD")).Text);
}
string strMSPSD = Convert.ToString(((TextBox)gr.FindControl("txtMSPSD")).Text);
if (strMSPSD == "")
{
objUI.MSPSD = Convert.ToInt16(null);
}
else
{
objUI.MSPSD = Convert.ToInt16(((TextBox)gr.FindControl("txtMSPSD")).Text);
}
string strDHC = Convert.ToString(((TextBox)gr.FindControl("txtDHC")).Text);
if (strDHC == "")
{
objUI.DHC = Convert.ToInt16(null);
}
else
{
objUI.DHC = Convert.ToInt16(((TextBox)gr.FindControl("txtDHC")).Text);
}
string strTaxable = Convert.ToString(((TextBox)gr.FindControl("txtTaxable")).Text);
if (strTaxable == "")
{
objUI.Taxable = Convert.ToDouble(null);
}
else
{
objUI.Taxable = Convert.ToDouble(((TextBox)gr.FindControl("txtTaxable")).Text);
}
string strCST = Convert.ToString(((TextBox)gr.FindControl("txtCST")).Text);
if (strCST == "")
{
objUI.CST = Convert.ToDouble(null);
}
else
{
objUI.CST = Convert.ToDouble(((TextBox)gr.FindControl("txtCST")).Text);
}
string strLST = Convert.ToString(((TextBox)gr.FindControl("txtLST")).Text);
if (strLST == "")
{
objUI.LST = Convert.ToDouble(null);
}
else
{
objUI.LST = Convert.ToDouble(((TextBox)gr.FindControl("txtLST")).Text);
}
string strSurch = Convert.ToString(((TextBox)gr.FindControl("txtSurch")).Text);
if (strSurch == "")
{
objUI.Surch = Convert.ToInt16(null);
}
else
{
objUI.Surch = Convert.ToInt16(((TextBox)gr.FindControl("txtSurch")).Text);
}
string strDely_Chgs = Convert.ToString(((TextBox)gr.FindControl("txtDelyChgs")).Text);
if (strDely_Chgs == "")
{
objUI.Dely_Chgs = Convert.ToInt16(null);
}
else
{
objUI.Dely_Chgs = Convert.ToInt16(((TextBox)gr.FindControl("txtDelyChgs")).Text);
}
string strEntityTot = Convert.ToString(((TextBox)gr.FindControl("txtEntityTot")).Text);
if (strEntityTot == "")
{
objUI.EntityTot = Convert.ToInt16(null);
}
else
{
objUI.EntityTot = Convert.ToInt16(((TextBox)gr.FindControl("txtEntityTot")).Text);
}
string strFreight = Convert.ToString(((TextBox)gr.FindControl("txtFreight")).Text);
if (strFreight == "")
{
objUI.Freight = Convert.ToDouble(null);
}
else
{
objUI.Freight = Convert.ToDouble(((TextBox)gr.FindControl("txtFreight")).Text);
}
objUI.Net_Amount = Convert.ToDouble(((TextBox)gr.FindControl("txtNetAmt")).Text);
objUI.Cost = Convert.ToInt16(((TextBox)gr.FindControl("txtCost")).Text);
objUI.SOff = Convert.ToString(((TextBox)gr.FindControl("txtSOff")).Text);
objUI.FromDate = Convert.ToDateTime(gr.Cells[27].Text);
objUI.ToDate = Convert.ToDateTime(gr.Cells[28].Text);
string strModelQuery = "Select * from ModelMapping where Material='" + strMaterial + "'";
DataTable dtModel = objQueryController.ExecuteQuery(strModelQuery);
if (dtModel != null)
{
if (dtModel.Rows.Count > 0)
{
foreach (DataRow drModel in dtModel.Rows)
{
objUI.ModelMappingID = Convert.ToInt32(drModel["ID"].ToString());
}
objCont.SaveSales(objUI);
rcount++;
}
else
{
string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[FromDate],[ToDate])";
strQuery += "Values ('" + ((TextBox)gr.FindControl("txtSno")).Text + "','" + ((TextBox)gr.FindControl("txtInvoiceNo")).Text + "','" + ((TextBox)gr.FindControl("txtDate")).Text + "','" + ((TextBox)gr.FindControl("txtDealerCode")).Text + "','" + ((TextBox)gr.FindControl("txtDealerName")).Text + "','" + ((TextBox)gr.FindControl("txtBlank")).Text + "','" + ((TextBox)gr.FindControl("txtModelCode")).Text + "','" + ((TextBox)gr.FindControl("txtQuantity")).Text + "','" + ((TextBox)gr.FindControl("txtSalesAmt")).Text + "','" + ((TextBox)gr.FindControl("txtDiscount")).Text + "','" + ((TextBox)gr.FindControl("txtSPLDIS")).Text + "','" + ((TextBox)gr.FindControl("txtExciseDuty")).Text + "','" + ((TextBox)gr.FindControl("txtEduCess")).Text + "','" + ((TextBox)gr.FindControl("txtHrECess")).Text + "','" + ((TextBox)gr.FindControl("txtLSPD")).Text + "','" + ((TextBox)gr.FindControl("txtMSPSD")).Text + "','" + ((TextBox)gr.FindControl("txtDHC")).Text + "','" + ((TextBox)gr.FindControl("txtTaxable")).Text + "','" + ((TextBox)gr.FindControl("txtCST")).Text + "','" + ((TextBox)gr.FindControl("txtLST")).Text + "','" + ((TextBox)gr.FindControl("txtSurch")).Text + "','" + ((TextBox)gr.FindControl("txtEntityTot")).Text + "','" + ((TextBox)gr.FindControl("txtDelyChgs")).Text + "','" + ((TextBox)gr.FindControl("txtFreight")).Text + "','" + ((TextBox)gr.FindControl("txtNetAmt")).Text + "','" + ((TextBox)gr.FindControl("txtCost")).Text + "','" + ((TextBox)gr.FindControl("txtSOff")).Text + "','" + Convert.ToDateTime(gr.Cells[27].Text) + "','" + Convert.ToDateTime(gr.Cells[28].Text) + "')";
objQueryController.ExecuteQuery(strQuery);
}
}
else
{
string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[FromDate],[ToDate])";
strQuery += "Values ('" + ((TextBox)gr.FindControl("txtSno")).Text + "','" + ((TextBox)gr.FindControl("txtInvoiceNo")).Text + "','" + ((TextBox)gr.FindControl("txtDate")).Text + "','" + ((TextBox)gr.FindControl("txtDealerCode")).Text + "','" + ((TextBox)gr.FindControl("txtDealerName")).Text + "','" + ((TextBox)gr.FindControl("txtBlank")).Text + "','" + ((TextBox)gr.FindControl("txtModelCode")).Text + "','" + ((TextBox)gr.FindControl("txtQuantity")).Text + "','" + ((TextBox)gr.FindControl("txtSalesAmt")).Text + "','" + ((TextBox)gr.FindControl("txtDiscount")).Text + "','" + ((TextBox)gr.FindControl("txtSPLDIS")).Text + "','" + ((TextBox)gr.FindControl("txtExciseDuty")).Text + "','" + ((TextBox)gr.FindControl("txtEduCess")).Text + "','" + ((TextBox)gr.FindControl("txtHrECess")).Text + "','" + ((TextBox)gr.FindControl("txtLSPD")).Text + "','" + ((TextBox)gr.FindControl("txtMSPSD")).Text + "','" + ((TextBox)gr.FindControl("txtDHC")).Text + "','" + ((TextBox)gr.FindControl("txtTaxable")).Text + "','" + ((TextBox)gr.FindControl("txtCST")).Text + "','" + ((TextBox)gr.FindControl("txtLST")).Text + "','" + ((TextBox)gr.FindControl("txtSurch")).Text + "','" + ((TextBox)gr.FindControl("txtEntityTot")).Text + "','" + ((TextBox)gr.FindControl("txtDelyChgs")).Text + "','" + ((TextBox)gr.FindControl("txtFreight")).Text + "','" + ((TextBox)gr.FindControl("txtNetAmt")).Text + "','" + ((TextBox)gr.FindControl("txtCost")).Text + "','" + ((TextBox)gr.FindControl("txtSOff")).Text + "','" + Convert.ToDateTime(gr.Cells[27].Text) + "','" + Convert.ToDateTime(gr.Cells[28].Text) + "')";
objQueryController.ExecuteQuery(strQuery);
}
}
catch
{
string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[FromDate],[ToDate])";
strQuery += "Values ('" + ((TextBox)gr.FindControl("txtSno")).Text + "','" + ((TextBox)gr.FindControl("txtInvoiceNo")).Text + "','" + ((TextBox)gr.FindControl("txtDate")).Text + "','" + ((TextBox)gr.FindControl("txtDealerCode")).Text + "','" + ((TextBox)gr.FindControl("txtDealerName")).Text + "','" + ((TextBox)gr.FindControl("txtBlank")).Text + "','" + ((TextBox)gr.FindControl("txtModelCode")).Text + "','" + ((TextBox)gr.FindControl("txtQuantity")).Text + "','" + ((TextBox)gr.FindControl("txtSalesAmt")).Text + "','" + ((TextBox)gr.FindControl("txtDiscount")).Text + "','" + ((TextBox)gr.FindControl("txtSPLDIS")).Text + "','" + ((TextBox)gr.FindControl("txtExciseDuty")).Text + "','" + ((TextBox)gr.FindControl("txtEduCess")).Text + "','" + ((TextBox)gr.FindControl("txtHrECess")).Text + "','" + ((TextBox)gr.FindControl("txtLSPD")).Text + "','" + ((TextBox)gr.FindControl("txtMSPSD")).Text + "','" + ((TextBox)gr.FindControl("txtDHC")).Text + "','" + ((TextBox)gr.FindControl("txtTaxable")).Text + "','" + ((TextBox)gr.FindControl("txtCST")).Text + "','" + ((TextBox)gr.FindControl("txtLST")).Text + "','" + ((TextBox)gr.FindControl("txtSurch")).Text + "','" + ((TextBox)gr.FindControl("txtEntityTot")).Text + "','" + ((TextBox)gr.FindControl("txtDelyChgs")).Text + "','" + ((TextBox)gr.FindControl("txtFreight")).Text + "','" + ((TextBox)gr.FindControl("txtNetAmt")).Text + "','" + ((TextBox)gr.FindControl("txtCost")).Text + "','" + ((TextBox)gr.FindControl("txtSOff")).Text + "','" + Convert.ToDateTime(gr.Cells[27].Text) + "','" + Convert.ToDateTime(gr.Cells[28].Text) +"')";
objQueryController.ExecuteQuery(strQuery);
}
string strDeleteQuery = "Delete from SalesTemp where ID=" + Convert.ToInt16(str);
objQueryController.ExecuteQuery(strDeleteQuery);
string strGridQuery = "Select * from SalesTemp";
DataTable dt = new DataTable();
dt = objQueryController.ExecuteQuery(strGridQuery);
grdSalesException.DataSource = dt;
grdSalesException.DataBind();
}
}
}