public async Task <IActionResult> Create([FromForm] AnalysisCode analysis_Code)
{
if (ModelState.IsValid)
{
bool isCodeExist = _context.AnalysisCode.Any(m => m.Code.Equals(analysis_Code.Code));
if (isCodeExist)
{
ModelState.AddModelError("Code", "Code Already Exists!");
return(View(analysis_Code));
//return RedirectToAction(nameof(Create), new { error = "Code exists" });
}
string newJson = JsonConvert.SerializeObject(analysis_Code);
bool isCodeExists = IsCodeExists(analysis_Code.Code);
analysis_Code.CompanyId = 123;
analysis_Code.IsUsed = true;
analysis_Code.Status = analysis_Code.Status;
analysis_Code.CreatedBy = _configuration.GetValue <string>("HardcodeValue:Createdby");
analysis_Code.CreatedDatetime = DateTime.UtcNow;
_context.Add(analysis_Code);
await _context.SaveChangesAsync();
AuditService.InsertActionLog(analysis_Code.CompanyId, analysis_Code.CreatedBy, "Create", "Analysis Code", null, newJson);
return(RedirectToAction(nameof(Index)));
}
return(View(analysis_Code));
}
public async Task <IActionResult> Edit(int id, [FromForm] AnalysisCode analysis_Code)
{
if (ModelState.IsValid)
{
try
{
bool isCodeExist = _context.AnalysisCode.Any(m => m.Code.Equals(analysis_Code.Code) && !m.Id.Equals(id));
if (isCodeExist)
{
ModelState.AddModelError("Code", "Code Already Exists!");
return(View(analysis_Code));
//return RedirectToAction(nameof(Index), new { error = "Code exists" });
}
AnalysisCode db_analysis_Code = _context.AnalysisCode.FirstOrDefault(m => m.Id.Equals(analysis_Code.Id));
if (analysis_Code == null || id != analysis_Code.Id)
{
return(NotFound());
}
OldDataAnalysis oldData = new OldDataAnalysis();
oldData.Code = db_analysis_Code.Code;
oldData.Name = db_analysis_Code.Name;
oldData.Remark = db_analysis_Code.Remark;
oldData.AnalysisNumber = db_analysis_Code.AnalysisNumber;
oldData.Status = db_analysis_Code.Status;
string oldJson = JsonConvert.SerializeObject(oldData);
string newJson = JsonConvert.SerializeObject(analysis_Code);
db_analysis_Code.Code = analysis_Code.Code;
db_analysis_Code.Name = analysis_Code.Name;
db_analysis_Code.Status = analysis_Code.Status;
db_analysis_Code.Remark = analysis_Code.Remark;
db_analysis_Code.AnalysisNumber = analysis_Code.AnalysisNumber;
db_analysis_Code.ModifiedBy = _configuration.GetValue <string>("HardcodeValue:Createdby");
db_analysis_Code.ModifiedDatetime = DateTime.UtcNow;
AuditService.InsertActionLog(db_analysis_Code.CompanyId, db_analysis_Code.CreatedBy, "Edit", "Analysis Code", oldJson, newJson);
_context.Update(db_analysis_Code);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Analysis_CodeExists(analysis_Code.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(analysis_Code));
}
// PUT: api/AnalysisCode/5
public void Put(int id, [FromBody] AnalysisCode data)
{
using (var db = new EModelsContext())
{
var eAnalysisCode = db.analysis_codes.Where(ac => ac.id.Equals(id)).SingleOrDefault();
if (eAnalysisCode != null)
{
eAnalysisCode.code = data.code;
db.SaveChanges();
}
}
}
// POST: api/AnalysisCode
public void Post([FromBody] AnalysisCode data)
{
using (var db = new EModelsContext())
{
analysis_codes analysisCode = new analysis_codes
{
code = data.code
};
db.analysis_codes.Add(analysisCode);
db.SaveChanges();
}
}
// GET: api/AnalysisCode/5
public AnalysisCode Get(int id)
{
AnalysisCode returnAnalysisCode = new AnalysisCode();
using (var db = new EModelsContext())
{
var eAnalysisCode = db.analysis_codes.Where(ac => ac.id.Equals(id)).Single();
returnAnalysisCode.id = eAnalysisCode.id;
returnAnalysisCode.code = eAnalysisCode.code;
}
return(returnAnalysisCode);
}
// GET: api/AnalysisCode
public IEnumerable <AnalysisCode> Get()
{
List <AnalysisCode> returnAnalysisCodes = new List <AnalysisCode>();
using (var db = new EModelsContext())
{
var result = db.analysis_codes.OrderByDescending(ac => ac.id).ToList();
foreach (var eAnalysisCode in result)
{
AnalysisCode returnAnalysisCode = new AnalysisCode();
returnAnalysisCode.id = eAnalysisCode.id;
returnAnalysisCode.code = eAnalysisCode.code;
returnAnalysisCodes.Add(returnAnalysisCode);
}
}
return(returnAnalysisCodes);
}
private bool UpdateDm(string code, string name, string analysisNo, string remark, bool status)
{
bool res = false;
try
{
AnalysisCode analysis_Code = _context.AnalysisCode.FirstOrDefault(m => m.Code.Equals(code));
OldDataAnalysis oldData = new OldDataAnalysis();
oldData.Code = analysis_Code.Code;
oldData.Name = analysis_Code.Name;
oldData.AnalysisNumber = analysis_Code.AnalysisNumber;
oldData.Remark = analysis_Code.Remark;
oldData.Status = analysis_Code.Status;
string oldJson = JsonConvert.SerializeObject(oldData);
string newJson = JsonConvert.SerializeObject(analysis_Code);
if (analysis_Code != null)
{
analysis_Code.Name = name;
analysis_Code.Code = code;
analysis_Code.AnalysisNumber = Convert.ToInt32(analysisNo);
analysis_Code.Status = status;
analysis_Code.Remark = remark;
analysis_Code.ModifiedDatetime = DateTime.UtcNow;
analysis_Code.ModifiedBy = _configuration.GetValue <string>("HardcodeValue:Modifiedby");
AuditService.InsertActionLog(analysis_Code.CompanyId, analysis_Code.CreatedBy, "Edit", "Analysis Code", oldJson, newJson);
_context.SaveChanges();
res = true;
}
}
catch (Exception ex)
{
res = false;
}
return(res);
}
private bool CreateDm(string code, string name, string analysisNo, string remark, bool status)
{
bool res = false;
AnalysisCode analysis_Code = new AnalysisCode();
try
{
NewDataAnalysis newData = new NewDataAnalysis();
newData.Code = code;
newData.Name = name;
newData.AnalysisNumber = Convert.ToInt32(analysisNo);
newData.Remark = remark;
newData.Status = status;
string newJson = JsonConvert.SerializeObject(newData);
analysis_Code.Code = code;
analysis_Code.Name = name;
analysis_Code.AnalysisNumber = Convert.ToInt32(analysisNo);
analysis_Code.Remark = remark;
analysis_Code.CompanyId = 123;
analysis_Code.IsUsed = true;
analysis_Code.Status = status;
analysis_Code.CreatedBy = _configuration.GetValue <string>("HardcodeValue:Createdby");
analysis_Code.CreatedDatetime = DateTime.UtcNow;
_context.Add(analysis_Code);
AuditService.InsertActionLog(analysis_Code.CompanyId, analysis_Code.CreatedBy, "Create", "Analysis Code", null, newJson);
_context.SaveChanges();
res = true;
}
catch (Exception ex)
{
res = false;
}
return(res);
}
public async Task <FileResult> Export()
{
string[] names = typeof(AnalysisCode).GetProperties().Select(property => property.Name).ToArray();
string[] columnNames = new string[] { "Code", "Name", "AnalysisNumber", "Remark", "Status" };
AnalysisCode entities = new AnalysisCode();
var customers = await _context.AnalysisCode.ToListAsync();
//Build the CSV file data as a Comma separated string.
string csv = string.Empty;
bool IsStatus = false;
foreach (string columnName in columnNames)
{
//Add the Header row for CSV file.
csv += columnName + ',';
}
//remove symbol "," behind
csv = csv.Remove(csv.Length - 1, 1);
//Add new line.
csv += "\r\n";
foreach (var customer in customers)
{
//Add the Data rows.
csv += customer.Code.Replace(",", ";") + ',';
csv += customer.Name.Replace(",", ";") + ',';
csv += customer.AnalysisNumber.ToString().Replace(",", ";") + ',';
if (customer.Remark != null)
{
csv += customer.Remark.Replace(",", ";") + ',';
}
else
{
customer.Remark = "";
csv += customer.Remark.Replace(",", ";") + ',';
}
if (customer.Status != false)
{
string Status = "YES";
csv += Status.Replace(",", ";");
}
if (customer.Status != true)
{
string Status = "NO";
csv += Status.Replace(",", ";");
}
//Add new line.
csv += "\r\n";
}
var file = "AnalysisCode.csv";
//var file = ViewData;
//Download the CSV file.
byte[] bytes = Encoding.ASCII.GetBytes(csv);
return(File(bytes, "application/text", file));
}
