public StockIn()
{
IDbManager dbManager = ObjectPool.Instance.Resolve <IDbManager>();
IDataCommand db = dbManager.GetDatabase(ApplicationSettings.Instance.Database.DefaultConnection.Name);
MaterialMaster = db.Query <MaterialType>("GetMaterial");
Material = MaterialMaster.GroupBy(x => x.Id).Select(d => d.First()).ToList();
db.Close();
}
public MaterialMasterDTO Update(MaterialMasterDTO obj)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
MaterialMaster tempObj = (from r in _unitOfWork.MaterialMaster.GenerateEntityAsIQueryable()
where r.SPEC_NO == obj.SPEC_NO && r.ID != obj.ID
select r).FirstOrDefault();
if (tempObj == null)
{
var response = _unitOfWork.MaterialMaster.FindById(obj.ID);
if (response != null)
{
response.NOMINAL_COMPOSITION = obj.NOMINAL_COMPOSITION;
response.PRODUCT_FORM = obj.PRODUCT_FORM;
response.CreatedBy = obj.CreatedBy;
response.CreatedDate = obj.CreatedDate;
response.ModifiedBy = obj.ModifiedBy;
response.ModifiedDate = DateTime.Now;
}
_unitOfWork.MaterialMaster.Update(response);
_unitOfWork.SaveChanges();
transaction.Commit();
return(new MaterialMasterDTO
{
ID = obj.ID,
Status = true,
StatusMessage = "Successfully updated",
StatusCode = 200
});
}
else
{
return(new MaterialMasterDTO
{
ID = tempObj.ID,
Status = false,
StatusMessage = "Error - Duplicate Material.",
StatusCode = 200
});
}
}
catch (Exception ex)
{
transaction.Rollback();
return(new MaterialMasterDTO()
{
ID = 0,
Status = false,
StatusMessage = ex.Message,
StatusCode = 200
});
}
}
}
public MaterialMasterDTO Create(MaterialMasterDTO obj)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
MaterialMaster tempObj = (from i in _unitOfWork.MaterialMaster.GenerateEntityAsIQueryable()
where i.SPEC_NO == obj.SPEC_NO
select i).FirstOrDefault();
if (tempObj == null)
{
var materialMaster = new MaterialMaster()
{
SPEC_NO = obj.SPEC_NO,
TYPE_GRADE = obj.TYPE_GRADE,
CreatedBy = obj.CreatedBy,
CreatedDate = DateTime.Now
};
_unitOfWork.MaterialMaster.Create(materialMaster);
_unitOfWork.SaveChanges();
transaction.Commit();
return(new MaterialMasterDTO
{
ID = materialMaster.ID,
Status = true,
StatusMessage = "Successfully created",
StatusCode = 200
});
}
else
{
return(new MaterialMasterDTO
{
ID = tempObj.ID,
Status = false,
StatusMessage = "Error - Duplicate Matrial - " + tempObj.SPEC_NO,
StatusCode = 200
});
}
}
catch (Exception ex)
{
transaction.Rollback();
return(new MaterialMasterDTO()
{
ID = 0,
Status = false,
StatusMessage = ex.Message,
StatusCode = 200
});
}
}
}
private void InitializeModel()
{
this.Title = string.Empty;
this.Deadline = DateTime.Now;
this.CreatedDate = DateTime.Now;
Qty = 1;
if (Finishing == null || MaterialMaster == null || Material == null)
{
IDbManager dbManager = ObjectPool.Instance.Resolve <IDbManager>();
IDataCommand db = dbManager.GetDatabase(ApplicationSettings.Instance.Database.DefaultConnection.Name);
Finishing = db.Query <KeyValueOption>("GetFinishing");
Size = db.Query <KeyValueOption>("GetSize");
MaterialMaster = db.Query <MaterialType>("GetMaterial");
Material = MaterialMaster.GroupBy(x => x.Id).Select(d => d.First()).ToList();
db.Close();
}
else
{
SelectedFinishing = null;
SelectedQuality = null;
SelectedMaterial = null;
}
}
public async Task<IActionResult> UpSertMaterial(MaterialMaster model)
{
if (model.Id == 0)
{
var createModel = CommanCRUDHelper.CommanCreateCode(model, 1);
var createResponse = await _IMaterialMasterService.CreateEntity(createModel);
var createdPrdctId = (await _IMaterialMasterService.GetList(x => x.IsActive == 1)).Max(x => x.Id);
var rateMasterResponse = await UpdateRateMaster(createdPrdctId, model.PerUnitCost);
return Json(ResponseHelper.GetResponseMessage(createResponse));
}
else
{
var updateModel = CommanCRUDHelper.CommanUpdateCode(model, 1);
var updateResponse = await _IMaterialMasterService.Update(updateModel);
var rateMasterResponse = await UpdateRateMaster(model.Id, model.PerUnitCost);
return Json(ResponseHelper.GetResponseMessage(updateResponse));
}
}
