protected void gvvendor_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblvendorId = (Label)gvvendor.Rows[e.RowIndex].FindControl("lblvendorId");
TextBox txtEditVendorName = (TextBox)gvvendor.Rows[e.RowIndex].FindControl("txtEditVendorName");
TextBox txtEditAddress = (TextBox)gvvendor.Rows[e.RowIndex].FindControl("txtEditAddress");
TextBox txtEditContactNo = (TextBox)gvvendor.Rows[e.RowIndex].FindControl("txtEditContactNo");
TextBox txtEditBillNo = (TextBox)gvvendor.Rows[e.RowIndex].FindControl("txtEditBillNo");
Domain.Vendor existing = venderrepo.GetById(Convert.ToInt32(lblvendorId.Text));
if (txtEditVendorName.Text != ("") && txtEditAddress.Text != ("") && txtEditContactNo.Text != ("") && txtEditBillNo.Text != (""))
{
if (existing != null)
{
existing.VendorName = txtEditVendorName.Text;
existing.Address = txtEditAddress.Text;
existing.ContactNo = txtEditContactNo.Text;
existing.BillNo = txtEditBillNo.Text;
existing.LastUpdatedBy = "admin";
existing.LastUpdationTime = DateTime.Now;
existing.TenantId = tenantId;
}
venderrepo.Edit(existing);
venderrepo.Save();
gvvendor.EditIndex = -1;
BindData();
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Vendor Sucessfully Updated');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Null Filled Not allowed');", true);
}
//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();
//gvvendor.EditIndex = -1;
//BindData();
}
protected void gvvendor_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("ADD"))
{
TextBox txtAddvendorName = (TextBox)gvvendor.FooterRow.FindControl("txtAddVendorName");
TextBox txtAddAddress = (TextBox)gvvendor.FooterRow.FindControl("txtAddAddress");
TextBox txtAddContactNo = (TextBox)gvvendor.FooterRow.FindControl("txtAddContactNo");
TextBox txtAddBillNo = (TextBox)gvvendor.FooterRow.FindControl("txtAddBillNo");
if (txtAddvendorName.Text != ("") && txtAddAddress.Text != ("") && txtAddContactNo.Text != ("") && txtAddBillNo.Text != (""))
{
Domain.Vendor vendor = new Domain.Vendor()
{
VendorName = txtAddvendorName.Text,
Address = txtAddAddress.Text,
ContactNo = txtAddContactNo.Text,
BillNo = txtAddBillNo.Text,
CreationTime = DateTime.Now,
LastUpdationTime = DateTime.Now,
CreatedBy = "admin",
LastUpdatedBy = "admin",
TenantId = tenantId,
};
venderrepo.Add(vendor);
venderrepo.Save();
BindData();
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Vendor Sucessfully Inserted');", true);
BindData();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Null Filled Not allowed');", true);
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
