public ActionResponse <CaseMovementDTO> Delete_Case(CaseMovementDTO model) { ActionResponse <CaseMovementDTO> response = new ActionResponse <CaseMovementDTO>() { Response = model, ResponseType = ResponseType.Ok }; using (MspDbContext _db = new MspDbContext()) { var SAleControl = _db.SaleOwner.FirstOrDefault(x => x.RecId == response.Response.SaleOwnerId); if (SAleControl != null) { response.ResponseType = ResponseType.Error; response.Message = "Satış Yapılmış Kayıttır. Silinemez."; return(response); } var entity = _db.CaseMovement.Where(x => x.RecId == response.Response.RecId).FirstOrDefault(); if (entity != null) { entity.Deleted = true; _db.Entry(entity).CurrentValues.SetValues(model); _db.Entry(entity).State = System.Data.Entity.EntityState.Modified; } _db.SaveChanges(); } return(response); }
public ActionResponse <SaleOwnerDTO> Update_Veresiye(SaleOwnerDTO model) { ActionResponse <SaleOwnerDTO> response = new ActionResponse <SaleOwnerDTO>() { Response = model, ResponseType = ResponseType.Ok }; using (MspDbContext _db = new MspDbContext()) { try { var entity = _db.SaleOwner.FirstOrDefault(x => x.RecId == response.Response.RecId); if (entity != null) { _db.Entry(entity).CurrentValues.SetValues(model); _db.Entry(entity).State = System.Data.Entity.EntityState.Modified; } _db.SaveChanges(); if (entity != null) { CaseMovementDTO caseMovement = new CaseMovementDTO() { CaseId = entity.CaseId, Doviz = entity.DovizId, RecordDate = DateTime.Now, Tutar = entity.TotalPrice, OdemeTuru = entity.PaymentType, CompanyRecId = entity.CompanyRecId, EvrakNo = "Parakende Satış", IslemTuru = 1, SaleOwnerId = entity.RecId, CariId = 1, Remark = "Veresiye Satış" }; _db.CaseMovement.Add(base.Map <CaseMovementDTO, CaseMovement>(caseMovement)); _db.SaveChanges(); } } catch (Exception e) { response.Message = e.ToString(); response.ResponseType = ResponseType.Error; } } return(response); }
public void Show(int RecId) { if (_FormOpenType == FormOpenType.New) { _CaseMovement = new CaseMovementDTO(); _CaseMovement.RecordDate = DateTime.Now; _CaseMovement.RecordUser = AppMain.User.username; _CaseMovement.CompanyRecId = AppMain.CompanyRecId; } if (_FormOpenType == FormOpenType.Edit) { _CaseMovement = _repository.Run <CaseService, CaseMovementDTO>(x => x.Get_CaseMovement(RecId)); } if (_FormOpenType == FormOpenType.Copy) { _CaseMovement = _repository.Run <CaseService, CaseMovementDTO>(x => x.Get_CaseMovement(RecId)); _CaseMovement.RecId = 0; } cbb_IslemTuru.Properties.DataSource = IslemTuru; cbb_IslemTuru.Properties.ValueMember = "Id"; cbb_IslemTuru.Properties.DisplayMember = "Value"; do_CaseRefresh(); do_OdemeTuru(); do_cashGroup(); _currencyTypes = _repository.Run <DefinitionsService, List <CurrencyTypeDTO> >(x => x.Get_List_CurrencyType()); bs_CurrencyType.DataSource = _currencyTypes; _currentTransactionsList = _repository.Run <CurrentTransactionsService, List <CTransactionsDTO> >(x => x.GetListCurrentTransactions()); bs_CariHesap.DataSource = _currentTransactionsList; bs_CaseMov.DataSource = _CaseMovement; this.ShowDialog(); }
public ActionResponse <CaseMovementDTO> SaveCaseMovement(CaseMovementDTO model) { ActionResponse <CaseMovementDTO> response = new ActionResponse <CaseMovementDTO>() { Response = model, ResponseType = ResponseType.Ok }; using (MspDbContext _db = new MspDbContext()) { try { if (model.RecId == 0) { _db.CaseMovement.Add(base.Map <CaseMovementDTO, CaseMovement>(model)); _db.SaveChanges(); } else { var entity = _db.CaseMovement.FirstOrDefault(x => x.RecId == response.Response.RecId); if (entity != null) { base.SetLog(entity, model, _db, response.Response.RecId); _db.Entry(entity).CurrentValues.SetValues(model); _db.Entry(entity).State = System.Data.Entity.EntityState.Modified; } } _db.SaveChanges(); } catch (Exception e) { response.Message = e.ToString(); response.ResponseType = ResponseType.Error; } } return(response); }
public ActionResponse <SaleRequest> Save_Sale(SaleRequest model) { ActionResponse <SaleRequest> response = new ActionResponse <SaleRequest>() { Response = model, ResponseType = ResponseType.Ok }; using (MspDbContext _db = new MspDbContext()) { using (DbContextTransaction transaction = _db.Database.BeginTransaction()) { try { int saleOwnerId = 0; if (response.Response.SaleOwnerDTO.RecId == 0) { SaleOwner saleOwner = base.Map <SaleOwnerDTO, SaleOwner>(model.SaleOwnerDTO); _db.SaleOwner.Add(saleOwner); _db.SaveChanges(); saleOwnerId = saleOwner.RecId; if (saleOwner.Veresiye != true) { CaseMovementDTO caseMovement = new CaseMovementDTO() { CaseId = model.SaleOwnerDTO.CaseId, Doviz = model.SaleOwnerDTO.DovizId, RecordDate = model.SaleOwnerDTO.Date, Tutar = model.SaleOwnerDTO.TotalPrice, OdemeTuru = model.SaleOwnerDTO.PaymentType, CompanyRecId = model.SaleOwnerDTO.CompanyRecId, EvrakNo = "Parakende Satış", IslemTuru = 1, SaleOwnerId = saleOwnerId, CariId = 1 }; _db.CaseMovement.Add(base.Map <CaseMovementDTO, CaseMovement>(caseMovement)); _db.SaveChanges(); } } else { var entity = _db.SaleOwner.FirstOrDefault(x => x.RecId == response.Response.SaleOwnerDTO.RecId); if (entity != null) { _db.Entry(entity).CurrentValues.SetValues(model.SaleOwnerDTO); _db.Entry(entity).State = System.Data.Entity.EntityState.Modified; } } foreach (var item in model.List_SaleTrans) { if (item.RecId == 0) { item.SaleOwnerId = saleOwnerId; _db.SaleTrans.Add(base.Map <SaleTransDTO, SaleTrans>(item)); var product = _db.products.FirstOrDefault(x => x.PID == item.ProductId); if (product != null) { Products updatePro = new Products(); updatePro = product; updatePro.PTotal = updatePro.PTotal - item.ProductQuantity; var sqlUpdate = $"Update products set PTotal =@PTotal where PID ={item.ProductId}"; var _param = new SqlParameter[] { new SqlParameter { ParameterName = "PTotal", Value = updatePro.PTotal } }; _db.Database.ExecuteSqlCommand(sqlUpdate, _param.ToArray()); //_db.Entry(product).CurrentValues.SetValues(updatePro); //_db.Entry(product).State = System.Data.Entity.EntityState.Modified; ProductMovementDTO productMovement = new ProductMovementDTO { ProductId = item.ProductId, Date = DateTime.Now, Quantity = Convert.ToInt32(item.ProductQuantity), Durum = "Satış", Deleted = false, Amount = item.ProductQuantity * item.ProductPrice, DurumType = 1, SaleOwnerId = saleOwnerId }; _db.ProductMovement.Add(base.Map <ProductMovementDTO, ProductMovement>(productMovement)); _db.SaveChanges(); } } else { var entity = _db.SaleTrans.FirstOrDefault(x => x.RecId == item.RecId); if (entity != null) { _db.Entry(entity).CurrentValues.SetValues(item); _db.Entry(entity).State = System.Data.Entity.EntityState.Modified; } } } _db.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); response.Message = e.ToString(); response.ResponseType = ResponseType.Error; } } } return(response); }