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