protected void gvHistoryTransactionDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblHistoryTransactionId = (Label)gvHistoryTransactionDetails.Rows[e.RowIndex].FindControl("lblHistoryTransactionId");
DropDownList ddlEditProduct = (DropDownList)gvHistoryTransactionDetails.Rows[e.RowIndex].FindControl("ddlEditProduct");
TextBox txtEditComments = (TextBox)gvHistoryTransactionDetails.Rows[e.RowIndex].FindControl("txtEditComments");
TextBox txtEditCount = (TextBox)gvHistoryTransactionDetails.Rows[e.RowIndex].FindControl("txtEditCount");
TextBox txtEditTotalAmount = (TextBox)gvHistoryTransactionDetails.Rows[e.RowIndex].FindControl("txtEditTotalAmount");
Domain.Historytransaction existing = historytransactionRepo.GetById(Convert.ToInt32(lblHistoryTransactionId.Text));
if (existing != null)
{
existing.ProductId = Convert.ToInt32(ddlEditProduct.SelectedValue);
existing.Comments = txtEditComments.Text;
existing.Count = Convert.ToInt32(txtEditCount.Text);
existing.TotalAmount = Convert.ToDecimal(txtEditTotalAmount.Text);
existing.LastUpdatedBy = "admin";
existing.LastUpdationTime = DateTime.Now;
existing.TenantId = tenantId;
}
historytransactionRepo.Edit(existing);
historytransactionRepo.Save();
gvHistoryTransactionDetails.EditIndex = -1;
BindData();
//conn.Open();
//string cmdstr = "update EmployeeDetails set name=@name,designation=@designation,city=@city,country=@country where empid=@empid";
//SqlCommand cmd = new SqlCommand(cmdstr, conn);
//cmd.Parameters.AddWithValue("@empid", lblEditEmpID.Text);
//cmd.Parameters.AddWithValue("@name", txtEditName.Text);
//cmd.Parameters.AddWithValue("@designation", txtEditDesignation.Text);
//cmd.Parameters.AddWithValue("@city", txtEditCity.Text);
//cmd.Parameters.AddWithValue("@country", txtEditCountry.Text);
//cmd.ExecuteNonQuery();
//conn.Close();
//gvHistoryTransactionDetails.EditIndex = -1;
//BindData();
}
protected void gvHistoryTransactionDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("ADD"))
{
DropDownList ddlAddProduct = (DropDownList)gvHistoryTransactionDetails.FooterRow.FindControl("ddlAddProduct");
TextBox txtAddComments = (TextBox)gvHistoryTransactionDetails.FooterRow.FindControl("txtAddComments");
TextBox txtAddCount = (TextBox)gvHistoryTransactionDetails.FooterRow.FindControl("txtAddCount");
TextBox txtAddTotalAmount = (TextBox)gvHistoryTransactionDetails.FooterRow.FindControl("txtAddTotalAmount");
Domain.Historytransaction historytransaction = new Domain.Historytransaction()
{
ProductId = Convert.ToInt32(ddlAddProduct.SelectedValue),
Comments = txtAddComments.Text,
Count = Convert.ToInt32(txtAddCount.Text),
TotalAmount = Convert.ToInt32(txtAddTotalAmount.Text),
CreationTime = DateTime.Now,
LastUpdationTime = DateTime.Now,
CreatedBy = "admin",
LastUpdatedBy = "admin",
TenantId = tenantId,
};
historytransactionRepo.Add(historytransaction);
historytransactionRepo.Save();
BindData();
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
