/// <summary>
/// This code is prepred by Mohammad Ariful Islam.
/// Software Engineer
/// FAS Finance & Investment Limited.
/// </summary>
public Int32 Insert(ThreeMonthSingleDAO aThreeMonthSingleDao)
{
ThreeMonthSingleDAL aThreeMonthSingleDal = new ThreeMonthSingleDAL();
try
{
return(aThreeMonthSingleDal.Insert(aThreeMonthSingleDao));
}
catch (Exception exception)
{
throw;
}
finally
{
aThreeMonthSingleDal = null;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
aThreeMonthSingleDao.depositScheme = lblScheme.Text;
aThreeMonthSingleDao.depositDate = Convert.ToDateTime(txtDepositDate.Text);
aThreeMonthSingleDao.tdrSlNo = txtTdrNo.Text.Trim();
aThreeMonthSingleDao.accountNumber = txtAccNo.Text.Trim();
aThreeMonthSingleDao.clientName = txtClientName.Text.Trim();
aThreeMonthSingleDao.fatherName = txtFatherName.Text.Trim();
aThreeMonthSingleDao.motherName = txtMotherName.Text.Trim();
aThreeMonthSingleDao.spouseName = txtSpouseName.Text.Trim();
aThreeMonthSingleDao.religion = txtReligion.Text.Trim();
aThreeMonthSingleDao.DOB = Convert.ToDateTime(txtDOB.Text.Trim());
aThreeMonthSingleDao.sex = ddlSex.SelectedValue;
aThreeMonthSingleDao.nationality = txtNationality.Text.Trim();
aThreeMonthSingleDao.id = ddlID.SelectedValue;
aThreeMonthSingleDao.idNo = txtIdNo.Text.Trim();
aThreeMonthSingleDao.occupation = txtOccupation.Text.Trim();
aThreeMonthSingleDao.organization = txtOrganization.Text.Trim();
aThreeMonthSingleDao.designation = txtDesignation.Text.Trim();
aThreeMonthSingleDao.officeAddress = txtOfficeAddress.Text.Trim();
aThreeMonthSingleDao.presentAddress = txtPresenetAdd.Text.Trim();
aThreeMonthSingleDao.permAddress = txtPermanentAdd.Text.Trim();
aThreeMonthSingleDao.phone = txtPhone.Text.TrimEnd();
aThreeMonthSingleDao.mobile = txtMobile.Text.Trim();
aThreeMonthSingleDao.email = txtEmail.Text.Trim();
aThreeMonthSingleDao.fax = txtFax.Text.Trim();
aThreeMonthSingleDao.depAmount = txtDepAmount.Text.Trim();
aThreeMonthSingleDao.depTenure = txtDepTenure.Text.Trim();
aThreeMonthSingleDao.depDateIssue = Convert.ToDateTime(txtDateIssue.Text.Trim());
aThreeMonthSingleDao.depDateMaturity = Convert.ToDateTime(txtDateMaturity.Text.Trim());
aThreeMonthSingleDao.cheqPoDDNo = txtChequeNo.Text.Trim();
aThreeMonthSingleDao.cheqDate = Convert.ToDateTime(txtChequeDate.Text.Trim());
aThreeMonthSingleDao.cheqBank = txtBank.Text.Trim();
aThreeMonthSingleDao.cheqBranch = txtBranch.Text.Trim();
aThreeMonthSingleDao.cheqTakaInWrd = txtTakaInWord.Text.Trim();
aThreeMonthSingleDao.sourceFunds = ddlFund.SelectedValue;
aThreeMonthSingleDao.interestRate = txtRate.Text.Trim();
aThreeMonthSingleDao.nameRM = txtRM.Text.Trim();
aThreeMonthSingleDao.nominee1 = txtNom1.Text.Trim();
aThreeMonthSingleDao.nominee1FatherName = txtFat1Name.Text.Trim();
aThreeMonthSingleDao.nominee1MotherName = txtMot1Name.Text.Trim();
aThreeMonthSingleDao.nominee1SpouseName = txtSP1Name.Text.Trim();
aThreeMonthSingleDao.nominee1Relation = txtRelation1.Text.Trim();
aThreeMonthSingleDao.nominee1Percentage = txtPercent1.Text.Trim();
//Image and Signature Insertion for First Nominee
aThreeMonthSingleDao.nominee1Image = FileUpload1.PostedFile.ContentLength;
aThreeMonthSingleDao.nominee1Signature = FileUpload3.PostedFile.ContentLength;
//byte[] msdata1=new byte[aThreeMonthSingleDao.nominee1Image];
aThreeMonthSingleDao.msdata1 = new byte[aThreeMonthSingleDao.nominee1Image];
FileUpload1.PostedFile.InputStream.Read(aThreeMonthSingleDao.msdata1, 0, aThreeMonthSingleDao.nominee1Image);
aThreeMonthSingleDao.msdata2 = new byte[aThreeMonthSingleDao.nominee1Signature];
FileUpload1.PostedFile.InputStream.Read(aThreeMonthSingleDao.msdata2, 0, aThreeMonthSingleDao.nominee1Signature);
aThreeMonthSingleDao.nominee2 = txtNom2.Text.Trim();
aThreeMonthSingleDao.nominee2FatherName = txtFat2Name.Text.Trim();
aThreeMonthSingleDao.nominee2MotherName = txtMot2Name.Text.Trim();
aThreeMonthSingleDao.nominee2SpouseName = txtSP2Name.Text.Trim();
aThreeMonthSingleDao.nominee2Relation = txtRelation2.Text.Trim();
aThreeMonthSingleDao.nominee2Percentage = txtPercent2.Text.Trim();
aThreeMonthSingleDao.nominee2Image = FileUpload2.PostedFile.ContentLength;
aThreeMonthSingleDao.nominee2Signature = FileUpload4.PostedFile.ContentLength;
//byte[] msdata1=new byte[aThreeMonthSingleDao.nominee1Image];
aThreeMonthSingleDao.msdata3 = new byte[aThreeMonthSingleDao.nominee2Image];
FileUpload1.PostedFile.InputStream.Read(aThreeMonthSingleDao.msdata3, 0, aThreeMonthSingleDao.nominee2Image);
aThreeMonthSingleDao.msdata4 = new byte[aThreeMonthSingleDao.nominee2Signature];
FileUpload1.PostedFile.InputStream.Read(aThreeMonthSingleDao.msdata4, 0, aThreeMonthSingleDao.nominee2Signature);
try
{
int result = aThreeMonthSingleBll.Insert(aThreeMonthSingleDao);
if (result > 0)
{
ClearControl();
Label1.Text = "Data Saved Successfully";
Label1.ForeColor = System.Drawing.Color.Green;
//Response.Redirect("ThreeMonthSingleDeposit.aspx");
}
}
catch (Exception exception)
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = "Error occured :" + exception.Message.ToString();
}
finally
{
aThreeMonthSingleDao = null;
aThreeMonthSingleBll = null;
}
}
public Int32 Insert(ThreeMonthSingleDAO aThreeMonthSingleDao)
{
int result;
try
{
SqlCommand cmd = new SqlCommand("spInsertSingle", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@depositScheme", aThreeMonthSingleDao.depositScheme);
cmd.Parameters.AddWithValue("@depositDate", aThreeMonthSingleDao.depositDate);
cmd.Parameters.AddWithValue("@tdrSlNo", aThreeMonthSingleDao.tdrSlNo);
cmd.Parameters.AddWithValue("@accountNumber", aThreeMonthSingleDao.accountNumber);
cmd.Parameters.AddWithValue("@clientName", aThreeMonthSingleDao.clientName);
cmd.Parameters.AddWithValue("@fatherName", aThreeMonthSingleDao.fatherName);
cmd.Parameters.AddWithValue("@motherName", aThreeMonthSingleDao.motherName);
cmd.Parameters.AddWithValue("@spouseName", aThreeMonthSingleDao.spouseName);
cmd.Parameters.AddWithValue("@DOB", aThreeMonthSingleDao.DOB);
cmd.Parameters.AddWithValue("@religion", aThreeMonthSingleDao.religion);
cmd.Parameters.AddWithValue("@sex", aThreeMonthSingleDao.sex);
cmd.Parameters.AddWithValue("@nationality", aThreeMonthSingleDao.nationality);
cmd.Parameters.AddWithValue("@id", aThreeMonthSingleDao.id);
cmd.Parameters.AddWithValue("@idNo", aThreeMonthSingleDao.idNo);
cmd.Parameters.AddWithValue("@occupation", aThreeMonthSingleDao.occupation);
cmd.Parameters.AddWithValue("@organization", aThreeMonthSingleDao.organization);
cmd.Parameters.AddWithValue("@designation", aThreeMonthSingleDao.designation);
cmd.Parameters.AddWithValue("@officeAddress", aThreeMonthSingleDao.officeAddress);
cmd.Parameters.AddWithValue("@presentAddress", aThreeMonthSingleDao.presentAddress);
cmd.Parameters.AddWithValue("@permAddress", aThreeMonthSingleDao.permAddress);
cmd.Parameters.AddWithValue("@phone", aThreeMonthSingleDao.phone);
cmd.Parameters.AddWithValue("@mobile", aThreeMonthSingleDao.mobile);
cmd.Parameters.AddWithValue("@email", aThreeMonthSingleDao.email);
cmd.Parameters.AddWithValue("@fax", aThreeMonthSingleDao.fax);
cmd.Parameters.AddWithValue("@depAmount", aThreeMonthSingleDao.depAmount);
cmd.Parameters.AddWithValue("@depTenure", aThreeMonthSingleDao.depTenure);
cmd.Parameters.AddWithValue("@depDateIssue", aThreeMonthSingleDao.depDateIssue);
cmd.Parameters.AddWithValue("@depDateMaturity", aThreeMonthSingleDao.depDateMaturity);
cmd.Parameters.AddWithValue("@cheqPoDDNo", aThreeMonthSingleDao.cheqPoDDNo);
cmd.Parameters.AddWithValue("@cheqDate", aThreeMonthSingleDao.cheqDate);
cmd.Parameters.AddWithValue("@cheqBank", aThreeMonthSingleDao.cheqBank);
cmd.Parameters.AddWithValue("@cheqBranch", aThreeMonthSingleDao.cheqBranch);
cmd.Parameters.AddWithValue("@cheqTakaInWrd", aThreeMonthSingleDao.cheqTakaInWrd);
cmd.Parameters.AddWithValue("@sourceFunds", aThreeMonthSingleDao.sourceFunds);
cmd.Parameters.AddWithValue("@interestRate", aThreeMonthSingleDao.interestRate);
cmd.Parameters.AddWithValue("@nameRM", aThreeMonthSingleDao.nameRM);
cmd.Parameters.AddWithValue("@nominee1", aThreeMonthSingleDao.nominee1);
cmd.Parameters.AddWithValue("@nominee1FatherName", aThreeMonthSingleDao.nominee1FatherName);
cmd.Parameters.AddWithValue("@nominee1MotherName", aThreeMonthSingleDao.nominee1MotherName);
cmd.Parameters.AddWithValue("@nominee1SpouseName", aThreeMonthSingleDao.nominee1SpouseName);
cmd.Parameters.AddWithValue("@nominee1Relation", aThreeMonthSingleDao.nominee1Relation);
cmd.Parameters.AddWithValue("@nominee1Percentage", aThreeMonthSingleDao.nominee1Percentage);
cmd.Parameters.AddWithValue("@nominee1Image", aThreeMonthSingleDao.msdata1);
cmd.Parameters.AddWithValue("@nominee1Signature", aThreeMonthSingleDao.msdata2);
cmd.Parameters.AddWithValue("@nominee2", aThreeMonthSingleDao.nominee2);
cmd.Parameters.AddWithValue("@nominee2FatherName", aThreeMonthSingleDao.nominee2FatherName);
cmd.Parameters.AddWithValue("@nominee2MotherName", aThreeMonthSingleDao.nominee2MotherName);
cmd.Parameters.AddWithValue("@nominee2SpouseName", aThreeMonthSingleDao.nominee2SpouseName);
cmd.Parameters.AddWithValue("@nominee2Relation", aThreeMonthSingleDao.nominee2Relation);
cmd.Parameters.AddWithValue("@nominee2Percentage", aThreeMonthSingleDao.nominee2Percentage);
cmd.Parameters.AddWithValue("@nominee2Image", aThreeMonthSingleDao.msdata3);
cmd.Parameters.AddWithValue("@nominee2Signature", aThreeMonthSingleDao.msdata4);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
result = cmd.ExecuteNonQuery();
cmd.Dispose();
if (result > 0)
{
return(result);
}
else
{
return(0);
}
}
catch (Exception exception)
{
throw;
}
finally
{
if (connection.State == ConnectionState.Closed)
{
connection.Close();
}
}
}
