protected void SupplierFormView_ItemInserting(object sender, FormViewInsertEventArgs e)
{
MfgDetails mfgInfo = new MfgDetails();
DataKey key = SupplierFormView.DataKey;
TextBox txtOrgName = (TextBox)SupplierFormView.FindControl("txtOrgName");
DropDownList ddlPartName = (DropDownList)SupplierFormView.FindControl("ddlPartName");
TextBox txtAddress = (TextBox)SupplierFormView.FindControl("txtAddress");
TextBox txtPhone = (TextBox)SupplierFormView.FindControl("txtPhone");
TextBox txtEmail = (TextBox)SupplierFormView.FindControl("txtEmail");
mfgInfo.OrgName = txtOrgName.Text;
mfgInfo.PartName = ddlPartName.Text;
mfgInfo.Address = txtAddress.Text;
mfgInfo.Phone = txtPhone.Text;
mfgInfo.Email = txtEmail.Text;
obj.InsertMfgDetails(mfgInfo);
bindgrid();
}
protected void SupplierFormView_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
DataKey key = SupplierFormView.DataKey;
MfgDetails mfgInfo = new MfgDetails();
Label lblMfgId = (Label)SupplierFormView.FindControl("lblMfgId");
mfgInfo.MfgID = Convert.ToInt32(key.Value.ToString());
obj.DeleteMfgDetails(mfgInfo);
bindgrid();
}
public void DeleteMfgDetails(MfgDetails mfgInfo)
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
SqlCommand cmd = new SqlCommand("delete from MFG_DETAILS where mfg_id=@MfgID", con);
cmd.Parameters.AddWithValue("@MfgID", mfgInfo.MfgID);
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertMfgDetails(MfgDetails mfgInfo)
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
SqlCommand cmd = new SqlCommand("insert into MFG_DETAILS (org_name,part_name,address,phone,email) values(@MfgName,@PartName,@Address,@Phone,@Email)", con);
cmd.Parameters.AddWithValue("@MfgName", mfgInfo.OrgName);
cmd.Parameters.AddWithValue("@PartName", mfgInfo.PartName);
cmd.Parameters.AddWithValue("@Address", mfgInfo.Address);
cmd.Parameters.AddWithValue("@Phone", mfgInfo.Phone);
cmd.Parameters.AddWithValue("@Email", mfgInfo.Email);
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdateMfgDetails(MfgDetails mfgInfo)
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
SqlCommand cmd = new SqlCommand("update MFG_DETAILS set org_name=@MfgName,part_name=@PartName, address=@Address,phone=@Phone,email=@Email where mfg_id=@MfgID", con);
cmd.Parameters.AddWithValue("@MfgID", mfgInfo.MfgID);
cmd.Parameters.AddWithValue("@MfgName", mfgInfo.OrgName);
cmd.Parameters.AddWithValue("@PartName", mfgInfo.PartName);
cmd.Parameters.AddWithValue("@Address", mfgInfo.Address);
cmd.Parameters.AddWithValue("@Phone", mfgInfo.Phone);
cmd.Parameters.AddWithValue("@Email", mfgInfo.Email);
cmd.ExecuteNonQuery();
con.Close();
}
protected void SupplierFormView_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
DataKey key = SupplierFormView.DataKey;
MfgDetails mfgInfo = new MfgDetails();
Label lblMfgId = (Label)SupplierFormView.FindControl("lblMfgId");
TextBox txtOrgName = (TextBox)SupplierFormView.FindControl("txtOrgName");
DropDownList ddlPartName = (DropDownList)SupplierFormView.FindControl("ddlPartName");
TextBox txtAddress = (TextBox)SupplierFormView.FindControl("txtAddress");
TextBox txtPhone = (TextBox)SupplierFormView.FindControl("txtPhone");
TextBox txtEmail = (TextBox)SupplierFormView.FindControl("txtEmail");
mfgInfo.MfgID = Convert.ToInt32(lblMfgId.Text);
mfgInfo.OrgName = txtOrgName.Text;
mfgInfo.PartName = ddlPartName.Text;
mfgInfo.Address = txtAddress.Text;
mfgInfo.Phone = txtPhone.Text;
mfgInfo.Email = txtEmail.Text;
obj.UpdateMfgDetails(mfgInfo);
bindgrid();
}
