public string SaveSpendingCenter(SpendingCenterModels spendingCenterModel)
{
SpendingCenterDTO spendingCenter = new SpendingCenterDTO();
MessageDTO message = new MessageDTO();
spendingCenter.Company = new CompanyDTO {
CompanyId = Convert.ToInt32(spendingCenterModel.CompanyId)
};
spendingCenter.SpendingCenterDescription = spendingCenterModel.SpendingCenterDescription;
spendingCenter.SpendingCenterId = Convert.ToInt32(spendingCenterModel.Id);
spendingCenter.SpendingCenterStatus = spendingCenterModel.SpendingCenterStatus;
spendingCenter.User = new UserDTO {
UserId = Convert.ToInt32(spendingCenterModel.UserId)
};
if (String.Compare(spendingCenterModel.Operation, "add", StringComparison.Ordinal) == 0)
{
message = business.SaveSpendingCenter(spendingCenter, "I");
}
else if (String.Compare(spendingCenterModel.Operation, "edit", StringComparison.Ordinal) == 0)
{
message = business.SaveSpendingCenter(spendingCenter, "U");
}
JavaScriptSerializer oSerializer = new JavaScriptSerializer();
string sJSON = oSerializer.Serialize(message);
return(sJSON);
}
/// <summary>
///
/// </summary>
/// <param name="whereClause"></param>
/// <param name="dataTable"></param>
/// <returns></returns>
public List <SpendingCenterDTO> GetSpendingCenters(Dictionary <string, string> whereClause, ref DataTable dataTable)
{
DataSet dataSet = new DataSet();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
var spendingCenters = new List <SpendingCenterDTO>();
int companyId = Convert.ToInt32(whereClause["companyId"]);
int pageSize = Convert.ToInt32(whereClause["pageSize"]);
int pageNumber = Convert.ToInt32(whereClause["pageNumber"]);
string sortColumn = whereClause["sortColumn"].ToString();
string sortOrder = whereClause["sortOrder"].ToString();
try
{
//Todos los registros
object[] parameters = new object[] { companyId, pageSize, pageNumber, sortColumn, sortOrder };
connector.FillDataSet(dataSet, CommandType.StoredProcedure, "GetSpendingCenter", parameters);
if (dataSet.Tables[1].Rows.Count > 0)
{
dataTable = dataSet.Tables[0];
foreach (DataRow row in dataSet.Tables[1].Rows)
{
SpendingCenterDTO spendingCenter = new SpendingCenterDTO
{
Company = new CompanyDTO {
CompanyId = Convert.ToInt32(row["COMPANY_ID"])
},
SpendingCenterDescription = row["SPENDING_CENTER_DESCRIPTION"].ToString(),
SpendingCenterId = Convert.ToInt32(row["SPENDING_CENTER_ID"]),
SpendingCenterStatus = row["SPENDING_CENTER_STATUS"].ToString()
};
spendingCenters.Add(spendingCenter);
}
}
else
{
spendingCenters = null;
}
}
catch (Exception exception)
{
spendingCenters = null;
}
finally
{
connector.Dispose();
}
return(spendingCenters);
}
//string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString();
#endregion
#region SpendingCenter
/// <summary>
///
/// </summary>
/// <param name="schedule"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SaveSpendingCenter(SpendingCenterDTO spendingCenter, string operation)
{
DataTable dataTable = new DataTable();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
MessageDTO message = new MessageDTO();
try
{
connector.BeginTransaction();
//Todos los registros
object[] parameters = new object[] { spendingCenter.SpendingCenterId, spendingCenter.Company.CompanyId,
spendingCenter.User.UserId, "", spendingCenter.SpendingCenterDescription,
spendingCenter.SpendingCenterStatus, operation };
//connector.ExecuteNonQuery(CommandType.StoredProcedure, "SaveSpendingCenter", parameters);
dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SaveSpendingCenter", parameters);
foreach (DataRow row in dataTable.Rows)
{
message.ErrorCode = row["ERROR_NUMBER"].ToString();
message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString();
}
if (message.ErrorCode == "0")
{
connector.Commit();
}
else
{
connector.RollBack();
}
}
catch (Exception exception)
{
message.ErrorCode = "-1";
message.ErrorMessage = exception.ToString();
connector.RollBack();
}
finally
{
connector.Dispose();
}
return(message);
}
public string DeleteSpendingCenter(int spendingCenterId, int companyId, int userId)
{
SpendingCenterDTO spendingCenter = new SpendingCenterDTO();
MessageDTO message = new MessageDTO();
spendingCenter.Company = new CompanyDTO {
CompanyId = companyId
};
spendingCenter.SpendingCenterDescription = "";
spendingCenter.SpendingCenterId = spendingCenterId;
spendingCenter.SpendingCenterStatus = "";
spendingCenter.User = new UserDTO {
UserId = userId
};
message = business.SaveSpendingCenter(spendingCenter, "D");
JavaScriptSerializer oSerializer = new JavaScriptSerializer();
string sJSON = oSerializer.Serialize(message);
return(sJSON);
}
/// <summary>
///
/// </summary>
/// <param name="spendingCenter"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SaveSpendingCenter(SpendingCenterDTO spendingCenter, string operation)
{
return(spendingCenterDao.SaveSpendingCenter(spendingCenter, operation));
}
