protected void GVClientsInvoice_RowDeleting(object sender, GridViewDeleteEventArgs e) { ClientsInvoiceDAL invoice = new ClientsInvoiceDAL { ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString() }; string IDString = GVClientsInvoice.DataKeys[e.RowIndex].Values["OrderNo"].ToString(); invoice.DeleteClientsInvoice(IDString); FetchClientsInvoice(search, search, company, sdate, edate); }
protected void FetchClientsInvoice(string OrderNo, string EmpID, int company, DateTime sdate, DateTime edate) { ClientsInvoiceDAL invoice = new ClientsInvoiceDAL { ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString() }; sdate = (string.IsNullOrEmpty(startDate.Text)) ? DateTime.MinValue : Convert.ToDateTime(startDate.Text); company = Convert.ToInt32(CompaniesList.SelectedValue); List <ClientsInvoice> ClientsInvoiceList = invoice.GetClientsInvoice(OrderNo, EmpID, sdate, edate, company); GVClientsInvoice.DataSource = ClientsInvoiceList; GVClientsInvoice.DataBind(); }
protected void GVClientsInvoice_RowUpdating(object sender, GridViewUpdateEventArgs e) { ClientsInvoiceDAL invoice = new ClientsInvoiceDAL { ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString() }; ClientsInvoice command = new ClientsInvoice(); //{ // OrderNo = (GVClientsInvoice.Rows[e.RowIndex].FindControl("LblInvoicesOrderNoEdit") as Label).Text, // EmployeeID = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesEmpID") as TextBox).Text, // FirstName = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesFName") as TextBox).Text, // LastName = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesLName") as TextBox).Text, // CatalogName = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesCName") as TextBox).Text, // Quantity = Convert.ToInt32((GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesQuantity") as TextBox).Text), // OrderDate = Convert.ToDateTime((GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesOrderDate") as TextBox).Text), // LocalCost = Convert.ToDouble((GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesLocalCost") as TextBox).Text), // //USDCost = Convert.ToDouble((GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesUSDCost") as TextBox).Text), // TotalLocalCost = Convert.ToDouble(GVClientsInvoice.DataKeys[e.RowIndex].Values["TotalLocalCost"].ToString()), // RedemptionPoints = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesRP") as TextBox).Text, // ReasonofReturn = (GVClientsInvoice.Rows[e.RowIndex].FindControl("DDLInvoicesReason") as DropDownList).SelectedValue, // Country = GVClientsInvoice.DataKeys[e.RowIndex].Values[2].ToString() //}; command.OrderNo = (GVClientsInvoice.Rows[e.RowIndex].FindControl("LblInvoicesOrderNoEdit") as Label).Text; command.EmployeeID = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesEmpID") as TextBox).Text; command.FirstName = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesFName") as TextBox).Text; command.LastName = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesLName") as TextBox).Text; command.CatalogName = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesCName") as TextBox).Text; command.Quantity = Convert.ToInt32((GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesQuantity") as TextBox).Text); command.OrderDate = Convert.ToDateTime((GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesOrderDate") as TextBox).Text); command.LocalCost = Convert.ToDouble((GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesLocalCost") as TextBox).Text); //USDCost = Convert.ToDouble((GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesUSDCost") as TextBox).Text); command.TotalLocalCost = Convert.ToDouble(GVClientsInvoice.DataKeys[e.RowIndex].Values["TotalLocalCost"].ToString()); command.RedemptionPoints = (GVClientsInvoice.Rows[e.RowIndex].FindControl("TxtInvoicesRP") as TextBox).Text; command.ReasonofReturn = (GVClientsInvoice.Rows[e.RowIndex].FindControl("DDLInvoicesReason") as DropDownList).SelectedValue; command.Country = GVClientsInvoice.DataKeys[e.RowIndex].Values[2].ToString(); invoice.InsertClientsInvoice(command); GVClientsInvoice.EditIndex = -1; FetchClientsInvoice(search, search, company, sdate, edate); }