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