public bool InsertRole(UserRole request)
{
try
{
_db.Insert(request);
return(true);
}
catch (Exception ex)
{
Log.ErrorFormat("NewRole", ex.Message);
return(false);
}
}
public bool InsertBulkTerminal(List <TerminalRequest> param)
{
try
{
var terminal = new DolTerminal();
_db.Insert(terminal);
return(true);
}
catch (Exception ex)
{
Log.ErrorFormat("InsertBulkRequest", ex.Message);
return(false);
}
}
public bool InsertUser(UserDetailsRequest param)
{
try
{
//return true;
var user = new DolUser();
user.Firstname = param.FirstName;
user.Middlename = param.MiddleName;
user.Lastname = param.LastName;
user.Username = param.UserName;
user.Email = param.Email;
user.Password = param.Password;
user.Phoneno = param.PhoneNo;
user.Sex = param.Sex;
user.Roleid = param.RoleId;
user.Clientid = param.ClientId;
user.Userimg = param.UserImg;
user.Isuseractive = param.IsUserActive;
user.Isdelete = param.IsDelete;
user.Createdby = param.CreatedBy;
user.Createdon = param.CreatedOn;
_db.Insert(user);
return(true);
}
catch (Exception ex)
{
log.ErrorFormat("InsertNewUser", ex.Message);
return(false);
}
}
public bool InsertUser(UserDetails userDetails)
{
try
{
var user = new DolUser();
user.Firstname = userDetails.FirstName;
user.Middlename = userDetails.MiddleName;
user.Username = userDetails.UserName;
user.Email = userDetails.Email;
user.Password = userDetails.Password;
user.Phoneno = userDetails.PhoneNo;
user.Roleid = userDetails.RoleId;
user.Clientid = userDetails.ClientId;
user.Userimg = DoFileUpload(userDetails.UserImg);
user.Isuseractive = userDetails.IsUserActive;
user.Isdelete = userDetails.IsDelete;
user.Createdby = userDetails.CreatedBy;
user.Createdon = userDetails.CreatedOn;
_db.Insert(userDetails);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool InsertAudit(string UserName, string UserActivity, string Comment, DateTime EventDate, string SystemName, string SystemIp)
{
try
{
var audit = new AuditTrail();
audit.Username = UserName;
audit.Useractivity = UserActivity;
audit.Comment = Comment;
audit.Eventdate = EventDate;
audit.Systemname = SystemName;
audit.Systemip = SystemIp;
_db.Insert <AuditTrail>(audit);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool InsertStocks(StockRequest param)
{
try
{
var request = new DolStockedPart();
request.Itemname = param.ItemName;
request.Itemstatus = param.ItemStatus;
request.Serialno = param.SerialNo;
request.Stockdesc = param.StockDesc;
request.Stockedby = param.StockedBy;
request.Stockedon = param.StockedOn;
request.Stockqty = param.StockQty;
_db.Insert(request);
return(true);
}
catch (Exception ex)
{
log.Fatal("ClassName:InventoryManagement MethodName: InsertStock", ex);
return(false);
}
}
public bool InsertMenu(DolMenuItem MenuName)
{
try
{
_db.Insert(MenuName);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool InsertRoleMenu(RoleMenu role)
{
try
{
_db.Insert(role);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool InsertMenu(DolMenuItem MenuName)
{
try
{
_db.Insert(MenuName);
return(true);
}
catch (Exception ex)
{
Log.ErrorFormat("InsertMenu", ex.Message);
return(false);
}
}
public bool InsertBrand(string BrandName, string BrandDesc, bool IsBrandActive, string CreatedBy, string SystemIp, string SystemName)
{
try
{
var brand = new DolBrand();
brand.Brandname = BrandName;
brand.Branddesc = BrandDesc;
brand.Isbrandactive = IsBrandActive;
brand.Createdby = CreatedBy;
brand.Createdon = DateTime.Now;
brand.Createdby = CreatedBy;
_db.Insert(brand);
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool InsertClient(string ClientName, string ClientAlias, string ClientBanner, int RespTime, int RestTime, bool IsClientActive, string CreatedBy)
{
try
{
var client = new DolClient();
client.Clientname = ClientName;
client.Clientalias = ClientAlias;
client.Resptime = RespTime;
client.Resttime = RestTime;
client.Isclientactive = IsClientActive;
client.Createdon = DateTime.Now;
client.Createdby = CreatedBy;
_db.Insert(client);
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool InsertIncident(IncidentLogRequest request, out int IncidentId)
{
try
{
IncidentId = 0;
var param = new DolIncident();
param.Terminalno = request.TerminalNo;
param.Incidenttitle = request.IncidentTitle;
param.Incidentdesc = request.IncidentDesc;
param.Incidentpriority = request.IncidentPriority;
param.Loggedby = request.LoggedBy;
param.Loggedon = DateTime.Now;
_db.Insert(param);
IncidentId = Convert.ToInt32(param.Incidentid);
return(true);
}
catch (Exception ex)
{
log.Fatal("ClassName:IncidentManagement MethodName: InsertIncident", ex);
IncidentId = 0;
return(false);
}
}
public bool InsertClient(ClientRequest request)
{
try
{
var param = new DolClient();
param.Clientalias = request.ClientAlias;
param.Clientbanner = request.ClientBanner;
param.Clientname = request.ClientName;
param.Createdby = request.CreatedBy;
param.Createdon = request.CreatedOn;
param.Isclientactive = request.IsClientActive;
param.Resptimein = request.RespTimeIn;
param.Resptimeout = request.RespTimeOut;
param.Resttimein = request.RestTimeIn;
param.Resttimeout = request.RestTimeOut;
_db.Insert(request);
return(true);
}
catch (Exception ex)
{
Log.ErrorFormat("InsertClient", ex.Message);
return(false);
}
}