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); } }