public static ActionResponse IncomePriceAdd(DS_IncomePrice dS_IncomePrice)
{
string Id = Convert.ToInt32(dS_IncomePrice.DS_StockID.Value) + "" + Convert.ToInt32(dS_IncomePrice.ID);
dS_IncomePrice.ID = Convert.ToDecimal(Id);
foreach (var item in dS_IncomePrice.DS_IncomePriceItems)
{
string DS_IncomePriceID = Convert.ToInt32(dS_IncomePrice.DS_StockID) + "" + Convert.ToInt32(item.DS_IncomePriceID);
string Idd = Convert.ToInt32(dS_IncomePrice.DS_StockID) + "" + Convert.ToInt32(item.ID);
item.ID = Convert.ToDecimal(Idd);
}
try
{
var ctx = new MainDataContext();
var model = Mapper.Map <Entity.DS_IncomePrice>(dS_IncomePrice);
using (var transaction = ctx.Database.BeginTransaction())
{
ctx.Set <Entity.DS_IncomePrice>().Add(model);
var result = ctx.SaveChanges();
transaction.Commit();
_logger.Info($"Save({string.Join(",", dS_IncomePrice.ID)})");
return(ActionResponse.Succeed());
}
}
catch (Exception ex)
{
_logger.Error($"Save({string.Join(",", dS_IncomePrice.ID)}), Exception: {ex}");
return(ActionResponse.Failure(ex.Message));
}
}
public List <DS_IncomePrice> GetIncomePriceList()
{
List <DS_IncomePrice> models = new List <DS_IncomePrice>();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
/* AND SendingStatus = 0*/
connection.Open();
string sqlQuery = @"SELECT TOP(100) * FROM CASPELERP.DS_IncomePrice WHERE DS_StockID = @Id AND StatusID = @StatusId AND SendingStatus = 0";
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.AddWithValue("@Id", Id);
command.Parameters.AddWithValue("@StatusId", IncomeStatusId);
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
DS_IncomePrice model = new DS_IncomePrice
{
ID = ReplaceNullDecimal(dataReader["ID"]),
StatusID = ReplaceNullDecimal(dataReader["StatusID"]),
OwnerID = ReplaceNullDecimal(dataReader["OwnerID"]),
BranchID = ReplaceNullDecimal(dataReader["BranchID"]),
CurrencyID = ReplaceNullDecimal(dataReader["CurrencyID"]),
CustomerID = ReplaceNullDecimal(dataReader["CustomerID"]),
PhysicalPersonID = ReplaceNullDecimal(dataReader["PhysicalPersonID"]),
ExternalDocNumber = ReplaceNullString(dataReader["ExternalDocNumber"]),
ExternalDocDate = ReplaceNullDateTime(dataReader["ExternalDocDate"]),
CreateDate = ReplaceNullDateTime(dataReader["CreateDate"]),
IncomeDate = ReplaceNullDateTime(dataReader["IncomeDate"]),
DS_StockID = ReplaceNullDecimal(dataReader["DS_StockID"]),
RefIncomeTypeID = ReplaceNullDecimal(dataReader["RefIncomeTypeID"]),
Description = ReplaceNullString(dataReader["Description"]),
Contract = ReplaceNullString(dataReader["Contract"]),
ContractDate = ReplaceNullDateTime(dataReader["ContractDate"]),
LastPaymentDate = ReplaceNullDateTime(dataReader["LastPaymentDate"]),
DocDueDate = ReplaceNullDateTime(dataReader["DocDueDate"]),
PJProjectID = ReplaceNullDecimal(dataReader["PJProjectID"]),
OperationalDay = ReplaceNullDateTime(dataReader["OperationalDay"]),
DsPaymentTypeID = ReplaceNullDecimal(dataReader["DsPaymentTypeID"]),
};
int incomePriceId = Convert.ToInt32(model.ID);
IncomePriceUpdateStatus(incomePriceId);
model.DS_IncomePriceItems = GetIncomePriceItems(model.ID);
models.Add(model);
}
_logger.Info($"GetIncomePriceList({string.Join(",", Id)})");
return(models);
}
}
catch (Exception ex)
{
_logger.Error($"GetIncomePriceList({string.Join(",", Id)}), Exception: {ex.Message}");
return(models);
}
}
public static ActionResponse IncomePriceAdd(DS_IncomePrice dS_IncomePrice)
{
//string Id = 7 + "" + Convert.ToInt32(dS_IncomePrice.ID);
int Id = Convert.ToInt32(dS_IncomePrice.ID);
dS_IncomePrice.ID = Id;
dS_IncomePrice.StatusID = 20174;
dS_IncomePrice.OwnerID = 12;
dS_IncomePrice.BranchID = 1;
dS_IncomePrice.CurrencyID = 6;
dS_IncomePrice.CustomerID = 38375;
dS_IncomePrice.ExternalDocNumber = Id.ToString();
dS_IncomePrice.PhysicalPersonID = 38375;
dS_IncomePrice.DS_StockID = 7;
dS_IncomePrice.RefIncomeTypeID = 1;
dS_IncomePrice.DsPaymentTypeID = 1;
foreach (var item in dS_IncomePrice.DS_IncomePriceItems)
{
string Idd = Convert.ToInt32(dS_IncomePrice.DS_StockID) + "" + Convert.ToInt32(item.ID);
item.ID = Convert.ToDecimal(Idd);
item.DS_IncomePriceID = Convert.ToDecimal(dS_IncomePrice.ID);
//item.Quantity = 1;
item.Price = 1;
item.VatID = 3;
}
try
{
var ctx = new DataContext();
//var model = Mapper.Map<ERP.WebApi.Entity.DS_IncomePrice>(dS_IncomePrice);
using (var transaction = ctx.Database.BeginTransaction())
{
ctx.Set <DS_IncomePrice>().Add(dS_IncomePrice);
var result = ctx.SaveChanges();
transaction.Commit();
_logger.Info($"Save({string.Join(",", dS_IncomePrice)})");
return(ActionResponse.Succeed());
}
}
catch (Exception ex)
{
_logger.Error($"Save({string.Join(",", dS_IncomePrice)}), Exception: {ex.Message}");
return(ActionResponse.Failure(ex.Message));
}
}
