public static int UpdateCode(long CodeId, CodesModel code)
=> Update(CodesTable.TableName, new ParamtersMap
{
[CodesTable.CName] = code.CName,
[CodesTable.CMasterId] = code.CMasterId,
[CodesTable.CDesc] = code.CDesc
}, $"{CodesTable.CId}={CodeId}");
public static int InsertCode(out long insertId, CodesModel code)
{
var changedCount = Insert(out insertId, CodesTable.TableName, new ParamtersMap
{
[CodesTable.CName] = code.CName,
[CodesTable.CMasterId] = code.CMasterId,
[CodesTable.CDesc] = code.CDesc
});
return(changedCount);
}
public Boolean Add([FromBody] CodesModel model)
{
var db = _context.Codes.Where(m => m.Type == model.Type && m.Code == model.Code).FirstOrDefault();
if (db == null)
{
db = new Codes();
Mapper.Map(model, db);
_context.Codes.Add(db);
_context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public Boolean Edit([FromBody] CodesModel model)
{
try
{
var db = _context.Codes.Where(m => m.Type == model.Type && m.Code == model.Code).FirstOrDefault();
if (db != null)
{
Mapper.Map(model, db);
_context.Codes.Update(db);
_context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex) {
var a = ex.InnerException;
return(false);
}
}
