public int InsertNominee(NomineeEntity oNomineeEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("INSERT INTO tblNominee (NomineeID,NomineeRightPercentage,NomineeName,NomineeFatherName,NomineeRelationWithC,"
+ "NomineeSex,NomineeDOB,NomineeReligion,NomineeCountryID,NomineeNID,NomineeTIN,NomineePermanentAddress,NomineePermanentContact,NomineePresentAddress,"
+ "NomineePresentContact,ClientID,NomineeIsMature,NomineeCreateBy,NomineeLastModified)"
+ "VALUES('" + oNomineeEntity.NomineeID + "','" + oNomineeEntity.NomineeRightPercentage + "','" + oNomineeEntity.NomineeName + "',"
+ "'" + oNomineeEntity.NomineeFatherName + "','" + oNomineeEntity.NomineeRelationWithC + "','" + oNomineeEntity.NomineeSex + "','" + oNomineeEntity.NomineeDOB + "',"
+ "'" + oNomineeEntity.NomineeReligion + "','" + oNomineeEntity.NomineeCountryID + "','" + oNomineeEntity.NomineeNID + "','" + oNomineeEntity.NomineeTIN + "','" + oNomineeEntity.NomineePermanentAddress + "',"
+ "'" + oNomineeEntity.NomineePermanentContact + "','" + oNomineeEntity.NomineePresentAddress + "','" + oNomineeEntity.NomineePresentContact + "',"
+ "'" + oNomineeEntity.ClientID + "','" + oNomineeEntity.NomineeIsMature + "','" + oNomineeEntity.NomineeCreateBy + "','" + oNomineeEntity.NomineeLastModified + "')", con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int DeleteNominee(NomineeEntity oNomineeEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("DELETE FROM tblNominee WHERE NomSL=" + oNomineeEntity.NomSL, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int UpdateNominee(NomineeEntity oNomineeEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("UPDATE tblNominee SET NomineeRightPercentage='" + oNomineeEntity.NomineeRightPercentage + "',NomineeName='" + oNomineeEntity.NomineeName + "',"
+ "NomineeFatherName='" + oNomineeEntity.NomineeFatherName + "',NomineeRelationWithC='" + oNomineeEntity.NomineeRelationWithC + "',NomineeSex='" + oNomineeEntity.NomineeSex + "',NomineeDOB='" + oNomineeEntity.NomineeDOB + "',"
+ "NomineeReligion='" + oNomineeEntity.NomineeReligion + "',NomineeCountryID='" + oNomineeEntity.NomineeCountryID + "',NomineeNID='" + oNomineeEntity.NomineeNID + "',NomineeTIN='" + oNomineeEntity.NomineeTIN + "',"
+ "NomineePermanentAddress='" + oNomineeEntity.NomineePermanentAddress + "',NomineePermanentContact='" + oNomineeEntity.NomineePermanentContact + "',NomineePresentAddress='" + oNomineeEntity.NomineePresentAddress + "',NomineePresentContact='" + oNomineeEntity.NomineePresentContact + "',"
+ "ClientID='" + oNomineeEntity.ClientID + "',NomineeIsMature='" + oNomineeEntity.NomineeIsMature + "',NomineeLastModified='" + oNomineeEntity.NomineeLastModified + "' WHERE NomSl=" + oNomineeEntity.NomSL, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
