public bool UpdateClient(ClientEntity clientEntity)
{
bool result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientUpdate");
db.AddInParameter(dbCommand, "@ClientId", DbType.Guid, clientEntity.ClientId);
db.AddInParameter(dbCommand, "@Initials", DbType.String, clientEntity.Initials);
db.AddInParameter(dbCommand, "@Firstname", DbType.String, clientEntity.Firstname);
db.AddInParameter(dbCommand, "@MiddleName", DbType.String, clientEntity.MiddleName);
db.AddInParameter(dbCommand, "@LastName", DbType.String, clientEntity.LastName);
db.AddInParameter(dbCommand, "@DOB", DbType.Date, clientEntity.DOB);
db.AddInParameter(dbCommand, "@AddressLine1", DbType.String, clientEntity.AddressLine1);
db.AddInParameter(dbCommand, "@AddressLine2", DbType.String, clientEntity.AddressLine2);
db.AddInParameter(dbCommand, "@AddressLine3", DbType.String, clientEntity.AddressLine3);
db.AddInParameter(dbCommand, "@Telephone", DbType.String, clientEntity.Telephone);
db.AddInParameter(dbCommand, "@Fax", DbType.String, clientEntity.Fax);
db.AddInParameter(dbCommand, "@Email", DbType.String, clientEntity.Email);
db.AddInParameter(dbCommand, "@ContactPerson", DbType.String, clientEntity.ContactPerson);
db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, clientEntity.UpdatedBy);
db.ExecuteNonQuery(dbCommand);
result = true;
return result;
}
public bool UpdateClient(ClientEntity clientEntity)
{
return clientDao.UpdateClient(clientEntity);
}
public Guid InsertClient(ClientEntity clientEntity)
{
return clientDao.InsertClient(clientEntity);
}