// DataSet ds=new DataSet();
// SqlDataAdapter da=new SqlDataAdapter();
#endregion
#region Method
public int Insert(FFIL_Single aSingle)
{
using (SqlConnection connection = new SqlConnection(this.connection))
{
SqlCommand cmd = new SqlCommand("spSingle", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@singleId", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@depositDate", SqlDbType.DateTime).Value = aSingle.depositDate;
cmd.Parameters.Add("@tdrSlNo", SqlDbType.Int).Value = aSingle.tdrSlNo;
cmd.Parameters.Add("@accountNumber", SqlDbType.Int).Value = aSingle.accountNumber;
cmd.Parameters.Add("@clientName", SqlDbType.VarChar).Value = aSingle.clientName;
cmd.Parameters.Add("@fatherName", SqlDbType.VarChar).Value = aSingle.fatherName;
cmd.Parameters.Add("@motherName", SqlDbType.VarChar).Value = aSingle.motherName;
cmd.Parameters.Add("@spouseName", SqlDbType.VarChar).Value = aSingle.spouseName;
cmd.Parameters.Add("@DOB", SqlDbType.DateTime).Value = aSingle.DOB;
cmd.Parameters.Add("@sex", SqlDbType.VarChar).Value = aSingle.sex;
cmd.Parameters.Add("@religion", SqlDbType.VarChar).Value = aSingle.religion;
cmd.Parameters.Add("@nationality", SqlDbType.VarChar).Value = aSingle.nationality;
cmd.Parameters.Add("@id", SqlDbType.VarChar).Value = aSingle.id;
cmd.Parameters.Add("@idNo", SqlDbType.Int).Value = aSingle.idNo;
cmd.Parameters.Add("@occupation", SqlDbType.VarChar).Value = aSingle.occupation;
cmd.Parameters.Add("@organization", SqlDbType.VarChar).Value = aSingle.organization;
cmd.Parameters.Add("@designation", SqlDbType.VarChar).Value = aSingle.designation;
cmd.Parameters.Add("@officeAddress", SqlDbType.VarChar).Value = aSingle.officeAddress;
cmd.Parameters.Add("@permAddress", SqlDbType.VarChar).Value = aSingle.permAddress;
cmd.Parameters.Add("@phone", SqlDbType.VarChar).Value = aSingle.phone;
cmd.Parameters.Add("@mobile", SqlDbType.VarChar).Value = aSingle.mobile;
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = aSingle.email;
cmd.Parameters.Add("@fax", SqlDbType.Int).Value = aSingle.fax;
cmd.Parameters.Add("@depAmount", SqlDbType.Int).Value = aSingle.depAmount;
cmd.Parameters.Add("@depTenure", SqlDbType.NVarChar).Value = aSingle.depTenure;
cmd.Parameters.Add("@depDateIssue", SqlDbType.DateTime).Value = aSingle.depDateIssue;
cmd.Parameters.Add("@depDateMaturity", SqlDbType.DateTime).Value = aSingle.depDateMaturity;
cmd.Parameters.Add("@cheqPoDDNo", SqlDbType.Int).Value = aSingle.cheqPoDDNo;
cmd.Parameters.Add("@cheqDate", SqlDbType.DateTime).Value = aSingle.cheqDate;
cmd.Parameters.Add("@cheqBank", SqlDbType.VarChar).Value = aSingle.cheqBank;
cmd.Parameters.Add("@cheqBranch", SqlDbType.VarChar).Value = aSingle.cheqBranch;
cmd.Parameters.Add("@cheqTakaInWrd", SqlDbType.VarChar).Value = aSingle.cheqTakaInWrd;
cmd.Parameters.Add("@nominee1", SqlDbType.VarChar).Value = aSingle.nominee1;
cmd.Parameters.Add("@nominee1FatherName", SqlDbType.VarChar).Value = aSingle.nominee1FatherName;
cmd.Parameters.Add("@nominee1MotherName", SqlDbType.VarChar).Value = aSingle.nominee1MotherName;
cmd.Parameters.Add("@nominee1SpouseName", SqlDbType.VarChar).Value = aSingle.nominee1SpouseName;
cmd.Parameters.Add("@nominee1Relation", SqlDbType.VarChar).Value = aSingle.nominee1Relation;
cmd.Parameters.Add("@nominee1Percentage", SqlDbType.VarChar).Value = aSingle.nominee1Percentage;
cmd.Parameters.Add("@nominee2", SqlDbType.VarChar).Value = aSingle.nominee2;
cmd.Parameters.Add("@nominee2FatherName", SqlDbType.VarChar).Value = aSingle.nominee2FatherName;
cmd.Parameters.Add("@nominee2MotherName", SqlDbType.VarChar).Value = aSingle.nominee2MotherName;
cmd.Parameters.Add("@nominee2SpouseName", SqlDbType.VarChar).Value = aSingle.nominee2SpouseName;
cmd.Parameters.Add("@nominee2Relation", SqlDbType.VarChar).Value = aSingle.nominee2Relation;
cmd.Parameters.Add("@nominee2Percentage", SqlDbType.VarChar).Value = aSingle.nominee2Percentage;
cmd.Parameters.Add("@Type", SqlDbType.Int).Value = 0;
connection.Open();
result = cmd.ExecuteNonQuery();
connection.Close();
return result;
}
}
public int Insert(FFIL_Single aSingle)
{
return aSingleGateway.Insert(aSingle);
}