public void UpdateRecord(Objects.ShareMembers obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_ShareMembersUpdate"; cmd.Parameters.AddWithValue("@MemberID", obj.MemberID); cmd.Parameters.AddWithValue("@RegistrationDate", obj.RegistrationDate); cmd.Parameters.AddWithValue("@MemberPic", obj.MemberPic); cmd.Parameters.AddWithValue("@MemberName", obj.MemberName); cmd.Parameters.AddWithValue("@FatherName", obj.FatherName); cmd.Parameters.AddWithValue("@VillageName", obj.VillageName); cmd.Parameters.AddWithValue("@CityName", obj.CityName); cmd.Parameters.AddWithValue("@ContactNo", obj.ContactNo); cmd.Parameters.AddWithValue("@CNINCNo", obj.CNINCNo); cmd.Parameters.AddWithValue("@Occupation", obj.Occupation); cmd.Parameters.AddWithValue("@PropertDetail", obj.PropertDetail); cmd.Parameters.AddWithValue("@PostalAddress", obj.PostalAddress); cmd.Parameters.AddWithValue("@Remarks", obj.Remarks); cmd.Parameters.AddWithValue("@AccountNo", obj.AccountNo); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtName.Text.Trim() == string.Empty) { Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Enter Party Name."); txtName.Focus(); return; } Objects.ShareMembers obj = new Objects.ShareMembers(); obj.MemberID = Int64.Parse(txtID.Text); obj.RegistrationDate = dtRegisterDate.Value; obj.MemberName = txtName.Text.Trim(); obj.FatherName = txtFatherName.Text.Trim(); obj.ContactNo = txtContactNo.Text.Trim(); obj.CNINCNo = txtCNIC.Text.Trim(); obj.Occupation = txtOccupation.Text.Trim(); obj.VillageName = txtVillage.Text.Trim(); obj.CityName = txtCity.Text.Trim(); obj.PostalAddress = txtAddress.Text.Trim(); obj.PropertDetail = txtPropertyDetail.Text.Trim(); obj.Remarks = txtRemarks.Text.Trim(); obj.AccountNo = txtID.Tag.ToString(); if (imgLogo.Image != null) { MemoryStream ms = new MemoryStream(); imgLogo.Image.Save(ms, imgLogo.Image.RawFormat); byte[] arrayImage = ms.GetBuffer(); obj.MemberPic = arrayImage; } //Insert Account var AccDAL = new DAL.AccountChart(); AccDAL.connectionstring = objDAL.connectionstring; if (!vOpenMode) { Objects.AccountChart objAcc = new Objects.AccountChart(); objAcc.AccountNo = AccDAL.getNextNo("ASSET").ToString(); objAcc.AccountTitle = obj.MemberName; objAcc.AccountType = "ASSET"; objAcc.AccountSubType = "Member"; objAcc.IsParty = true; objAcc.IsBank = false; objAcc.OpeningDebit = 0; objAcc.OpeningCredit = 0; AccDAL.InsertRecord(objAcc); //Insert //obj.MemberID = objDAL.getNextNo(); obj.AccountNo = objAcc.AccountNo; objDAL.InsertRecord(obj); } else { // UPdate Account Objects.AccountChart objAcc = new Objects.AccountChart(); objAcc.AccountNo = obj.AccountNo; objAcc.AccountTitle = obj.MemberName; objAcc.AccountType = "ASSET"; objAcc.AccountSubType = "Member"; objAcc.IsParty = true; objAcc.IsBank = false; objAcc.OpeningDebit = 0; objAcc.OpeningCredit = 0; AccDAL.UpdateRecord(objAcc); objDAL.UpdateRecord(obj); } Message.ShowMessage(MyMessages.MessageType.SaveRecord); LoadGrid(); btnClear_Click(sender, e); } catch (Exception exc) { Message.ShowMessage(MyMessages.MessageType.Error, exc.Message); } }