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