public DataSet AddLocation(ManageLocationBo locationBo)
{
var transactionStatus = new TransactionStatus();
var location = BuiltManageLocationDomain(locationBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@city", location.City), //1
new SqlParameter("@location", location.Location), //2
new SqlParameter("@pincode", location.Pincode), //3
new SqlParameter("@state", location.State), //4
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddCityLocation_Master", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(ds);
}
public TransactionStatus UpdateLocation(ManageLocationBo locationBo)
{
var transactionStatus = new TransactionStatus();
var location = BuiltManageLocationDomain(locationBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@id", location.Id), //0
new SqlParameter("@city", location.City), //1
new SqlParameter("@location", location.Location), //2
new SqlParameter("@pincode", location.Pincode), //3
new SqlParameter("@state", location.State), //4
new SqlParameter("@output", SqlDbType.Int), //4
};
Params[5].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateCityLocation_Master", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(transactionStatus);
}
private ManageLocation BuiltManageLocationDomain(ManageLocationBo locationBo)
{
return((ManageLocation) new ManageLocation().InjectFrom(locationBo));
}
