public bool Province_Update(IdentityProvince identity)
{
//Common syntax
var sqlCmd = @"Province_Update";
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@Id", identity.Id },
{ "@Name", identity.Name },
{ "@Code", identity.Code },
{ "@Status", identity.Status }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
MsSqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, sqlCmd, parameters);
}
}
catch (Exception ex)
{
var strError = "Failed to execute Province_Update. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(true);
}
public IdentityProvince Province_GetById(int Id)
{
var info = new IdentityProvince();
var sqlCmd = @"Province_GetById";
var parameters = new Dictionary <string, object>
{
{ "@Id", Id }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters))
{
while (reader.Read())
{
info = ExtractProvinceData(reader);
}
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute Province_GetById. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(info);
}
private IdentityProvince ExtractProvinceData(IDataReader reader)
{
var record = new IdentityProvince();
//Seperate properties
record.Id = Utils.ConvertToInt32(reader["Id"]);
record.Name = reader["Name"].ToString();
record.Code = reader["Code"].ToString();
record.Status = Utils.ConvertToInt32(reader["Status"]);
return(record);
}
public bool Province_Update(IdentityProvince identity)
{
return(myRepository.Province_Update(identity));
}
public bool Province_Insert(IdentityProvince identity)
{
return(myRepository.Province_Insert(identity));
}
