public static ActionResponse IncomePriceSimpleItemItemAdd(DS_IncomePriceItems dS_IncomePriceItems, decimal stockId, decimal incomePriceItemId)
{
var dS_IncomePriseSimpleItemItems = Mapper.Map <DS_IncomePriseSimpleItemItems>(dS_IncomePriceItems);
string Id = Convert.ToInt32(stockId) + "" + Convert.ToInt32(dS_IncomePriseSimpleItemItems.ID);
dS_IncomePriseSimpleItemItems.ID = Convert.ToDecimal(Id);
dS_IncomePriseSimpleItemItems.IdParent = incomePriceItemId;
dS_IncomePriseSimpleItemItems.Moisture = 18;
dS_IncomePriseSimpleItemItems.IsFirst = true;
try
{
var ctx = new DataContext();
//var model = Mapper.Map<DS_IncomePriseSimpleItemItems>(dS_IncomePriseSimpleItemItems);
using (var transaction = ctx.Database.BeginTransaction())
{
ctx.Set <DS_IncomePriseSimpleItemItems>().Add(dS_IncomePriseSimpleItemItems);
var result = ctx.SaveChanges();
transaction.Commit();
_logger.Info($"Save({string.Join(",", dS_IncomePriseSimpleItemItems)})");
return(ActionResponse.Succeed());
}
}
catch (Exception ex)
{
_logger.Error($"Save({string.Join(",", dS_IncomePriseSimpleItemItems)}), Exception: {ex.Message}");
return(ActionResponse.Failure(ex.Message));
}
}
public List <DS_IncomePriceItems> GetIncomePriceItems(decimal IncomePriceID)
{
List <DS_IncomePriceItems> models = new List <DS_IncomePriceItems>();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string sqlQuery = @"SELECT * FROM CASPELERP.DS_IncomePriceItems WHERE DS_IncomePriceID = @IncomePriceID";
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.AddWithValue("@IncomePriceID", IncomePriceID);
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
DS_IncomePriceItems model = new DS_IncomePriceItems
{
ID = ReplaceNullDecimal(dataReader["ID"]),
DS_IncomePriceID = ReplaceNullDecimal(dataReader["DS_IncomePriceID"]),
ProductUnitID = ReplaceNullDecimal(dataReader["ProductUnitID"]),
Quantity = ReplaceNullDecimal(dataReader["Quantity"]),
Price = ReplaceNullDecimal(dataReader["Price"]),
StatusID = ReplaceNullDecimal(dataReader["StatusID"]),
SerialNumber = ReplaceNullString(dataReader["SerialNumber"]),
QualityID = ReplaceNullDecimal(dataReader["QualityID"]),
AddressID = ReplaceNullDecimal(dataReader["AddressID"]),
OwnerID = ReplaceNullDecimal(dataReader["OwnerID"]),
BranchID = ReplaceNullDecimal(dataReader["BranchID"]),
CurrencyID = ReplaceNullDecimal(dataReader["CurrencyID"]),
CustomerID = ReplaceNullDecimal(dataReader["CustomerID"]),
ContractID = ReplaceNullDecimal(dataReader["ContractID"]),
Description = ReplaceNullString(dataReader["Description"]),
VHFNum = ReplaceNullString(dataReader["VHFNum"]),
DocDueDate = ReplaceNullDateTime(dataReader["DocDueDate"]),
OperationalDay = ReplaceNullDateTime(dataReader["OperationalDay"]),
Picture = ReplaceNullByte(dataReader["Picture"]),
VatID = ReplaceNullDecimal(dataReader["VatID"]),
VatPrice = ReplaceNullDecimal(dataReader["VatPrice"]),
VHFDate = ReplaceNullDateTime(dataReader["VHFDate"]),
HasWarranty = ReplaceNullBool(dataReader["HasWarranty"]),
WarrantyType = ReplaceNullString(dataReader["WarrantyType"]),
WarrantyMonth = ReplaceNullDecimal(dataReader["WarrantyMonth"]),
WarrantyDescription = ReplaceNullString(dataReader["WarrantyDescription"]),
Code = ReplaceNullString(dataReader["Code"]),
};
model.DS_IncomePriseSimpleItem = GetIncomePriseSimpleItemItems(model.ID);
models.Add(model);
}
_logger.Info($"GetIncomePriceItems({string.Join(",", IncomePriceID)})");
return(models);
}
}
catch (Exception ex)
{
_logger.Error($"GetIncomePriceItems({string.Join(",", IncomePriceID)}), Exception: {ex.Message}");
return(models);
}
}
