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(); }