//public long GetMaxId()
//{
// long id = 0;
// try
// {
// _objCashierCounterEntity = _dbContext.POS_CASHIER_COUNTER.OrderByDescending(x => x.USER_ID).FirstOrDefault();
// if (_objCashierCounterEntity.USER_ID.ToString() == null)
// id = 1;
// else
// id = _objCashierCounterEntity.USER_ID + 1;
// return id;
// }
// catch (Exception ex)
// {
// ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
// throw new DALException();
// }
//}
//public string GetMaxCode()
//{
// string code = string.Empty;
// int maxCode = 0;
// try
// {
// _objCashierCounterEntity = _dbContext.POS_CASHIER_COUNTER.OrderByDescending(x => x.CODE).FirstOrDefault();
// if (_objCashierCounterEntity.CODE.ToString() == null)
// code = "0001";
// else
// maxCode = Formatter.SetValidValueToInt(_objCashierCounterEntity.CODE) + 1;
// code = maxCode.ToString().PadLeft(4, '0');
// return code;
// }
// catch (Exception ex)
// {
// ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
// throw new DALException();
// }
//}
public int Create(POS_CASHIER_COUNTER userModel)
{
int rowAffected = 0;
POS_CASHIER_COUNTER _objCashierCounterEntity = new POS_CASHIER_COUNTER();
try
{
_objCashierCounterEntity.COUNTER_DESC = userModel.COUNTER_DESC;
_objCashierCounterEntity.PC_NAME = userModel.PC_NAME;
_objCashierCounterEntity.IP_ADDRESS = userModel.MAC_ADDRESS;
_objCashierCounterEntity.ISACTIVE_FLAG = userModel.ISACTIVE_FLAG;
_objCashierCounterEntity.BRANCH_ID = userModel.BRANCH_ID;
_objCashierCounterEntity.ISPOSTED_FLAG = false;
_objCashierCounterEntity.CREATEDBY = userModel.CREATEDBY;
_objCashierCounterEntity.CREATEDWHEN = userModel.CREATEDWHEN;
_objCashierCounterEntity.MODIFIEDBY = userModel.MODIFIEDBY;
_dbContext.POS_CASHIER_COUNTER.Add(_objCashierCounterEntity);
rowAffected = _dbContext.SaveChanges();
return(rowAffected);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException("User Info not completed in Data Layer");
}
}
public int Update(POS_CASHIER_COUNTER userModel)
{
int rowAffected = 0;
POS_CASHIER_COUNTER entity = new POS_CASHIER_COUNTER();
try
{
//_dbContext.Entry(userModel).State = System.Data.Entity.EntityState.Modified;
entity = _dbContext.POS_CASHIER_COUNTER.Find(userModel.COUNTER_ID);
entity.COUNTER_DESC = userModel.COUNTER_DESC;
entity.PC_NAME = userModel.PC_NAME;
entity.IP_ADDRESS = userModel.MAC_ADDRESS;
entity.ISACTIVE_FLAG = userModel.ISACTIVE_FLAG;
entity.BRANCH_ID = userModel.BRANCH_ID;
entity.ISPOSTED_FLAG = false;
entity.CREATEDBY = userModel.CREATEDBY;
entity.CREATEDWHEN = userModel.CREATEDWHEN;
entity.MODIFIEDBY = userModel.MODIFIEDBY;
rowAffected = _dbContext.SaveChanges();
return(rowAffected);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException();
}
}
public Notify Update(POS_CASHIER_COUNTER CompanyModel)
{
try
{
int rowAffected = _objDALCashierCounter.Update(CompanyModel);
if (rowAffected > 0)
{
objNotify.RowEffected = 1;
objNotify.NotifyMessage = "Record Updated Successfully";
}
else
{
objNotify.RowEffected = 0;
objNotify.NotifyMessage = "Company Not Updated";
}
return(objNotify);
}
catch (Exception ex)
{
if (ex is DALException)
{
throw ex;
}
else
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
}
throw new BALException(ex.Message.ToString());
}
}
public ActionResult Create(POS_CASHIER_COUNTER pos_cashiercounter)
{
try
{
if (Session[SessionVariables.Session_UserInfo] != null)
{
if (ModelState.IsValid)
{
BranchList();
string hostName = Dns.GetHostName(); // Retrive the Name of HOST
//// Get the IP
string myIP = Dns.GetHostEntry(hostName).AddressList[0].ToString();
//string MAC = GetMacAddress().ToString();
pos_cashiercounter.PC_NAME = hostName;
pos_cashiercounter.IP_ADDRESS = myIP;
pos_cashiercounter.CREATEDBY = SessionHandling.UserInformation.USERNAME;
pos_cashiercounter.MODIFIEDBY = SessionHandling.UserInformation.USERNAME;
pos_cashiercounter.CREATEDWHEN = DateTime.Now;
db.POS_CASHIER_COUNTER.Add(pos_cashiercounter);
db.SaveChanges();
// objNotify = _objBALCahierCounter.Create(pos_cashiercounter);
if (objNotify.RowEffected > 0)
{
ShowAlert(AlertType.Success, objNotify.NotifyMessage);
return(RedirectToAction("Index"));
}
else
{
ShowAlert(AlertType.Error, objNotify.NotifyMessage);
}
}
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
error.Breadcrum = "Home > Cashier Counter > List > Create";
if (ex is BALException)
{
error.ErrorMsg = ex.Message.ToString() + "from " + ex.TargetSite.DeclaringType.Name + " method in " + ex.TargetSite.Name + " layer";
}
else
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.UI, ExceptionType.Error);
error.ErrorMsg = ex.Message.ToString() + "from " + ex.TargetSite.DeclaringType.Name + " method in " + ex.TargetSite.Name + " layer";
}
return(RedirectToAction("ShowErrorPage", "Master", error));
}
return(View(pos_cashiercounter));
}
public POS_CASHIER_COUNTER GetById(long?id)
{
try
{
_objCashierCounterEntity = _dbContext.POS_CASHIER_COUNTER.Find(id);
return(_objCashierCounterEntity);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException();
}
}
public ActionResult Edit(POS_CASHIER_COUNTER pos_cashiercounter)
{
try
{
if (Session[SessionVariables.Session_UserInfo] != null)
{
BranchList();
pos_cashiercounter.MODIFIEDBY = SessionHandling.UserInformation.USERNAME;
pos_cashiercounter.MODIFIEDWHEN = DateTime.Now;
if (ModelState.IsValid)
{
objNotify = _objBALCahierCounter.Update(pos_cashiercounter);
if (objNotify.RowEffected > 0)
{
ShowAlert(AlertType.Success, objNotify.NotifyMessage);
return(RedirectToAction("Index"));
}
else
{
ShowAlert(AlertType.Error, objNotify.NotifyMessage);
}
}
else
{
return(View(pos_cashiercounter));
}
// }
return(View(pos_cashiercounter));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
error.Breadcrum = "Home > Cashier Counter > List > Edit";
if (ex is BALException)
{
error.ErrorMsg = ex.Message.ToString() + "from " + ex.TargetSite.DeclaringType.Name + " method in " + ex.TargetSite.Name + " layer";
}
else
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.UI, ExceptionType.Error);
error.ErrorMsg = ex.Message.ToString() + "from " + ex.TargetSite.DeclaringType.Name + " method in " + ex.TargetSite.Name + " layer";
}
return(RedirectToAction("ShowErrorPage", "Master", error));
}
}
public List <POS_CASHIER_COUNTER> List()
{
List <POS_CASHIER_COUNTER> lst = new List <POS_CASHIER_COUNTER>();
try
{
//lst = _dbContext.POS_CASHIER_COUNTER.ToList();
var result = (from ctx in _dbContext.POS_CASHIER_COUNTER
join j in _dbContext.POS_CASHIER_COUNTER on ctx.BRANCH_ID equals j.BRANCH_ID
select new
{
CounterDesc = ctx.COUNTER_DESC,
PCName = ctx.PC_NAME,
IPAddress = ctx.IP_ADDRESS,
MacAddress = ctx.MAC_ADDRESS,
IsActive = ctx.ISACTIVE_FLAG,
BranchId = ctx.BRANCH_ID,
IsPosted = ctx.ISPOSTED_FLAG,
CreatedBy = ctx.CREATEDBY,
ModifiedBy = ctx.MODIFIEDBY,
CreatedWhen = ctx.CREATEDWHEN,
ModifiedWhen = ctx.MODIFIEDWHEN
}).ToList();
foreach (var item in result)
{
POS_CASHIER_COUNTER _entity = new POS_CASHIER_COUNTER();
_entity.COUNTER_DESC = item.CounterDesc;
_entity.PC_NAME = item.PCName;
_entity.IP_ADDRESS = item.IPAddress;
_entity.MAC_ADDRESS = item.MacAddress;
_entity.ISACTIVE_FLAG = item.IsActive;
_entity.BRANCH_ID = item.BranchId;
_entity.ISPOSTED_FLAG = item.IsPosted;
_entity.CREATEDBY = item.CreatedBy;
_entity.CREATEDWHEN = item.CreatedWhen;
_entity.MODIFIEDWHEN = item.ModifiedWhen;
lst.Add(_entity);
}
return(lst);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException("User Info not completed in Data Layer");
}
}
public int Delete(long id)
{
int rowAffected = 0;
try
{
_objCashierCounterEntity = _dbContext.POS_CASHIER_COUNTER.Find(id);
_dbContext.POS_CASHIER_COUNTER.Remove(_objCashierCounterEntity);
rowAffected = _dbContext.SaveChanges();
return(rowAffected);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException();
}
}
public POS_CASHIER_COUNTER GetById(long?id)
{
try
{
_objCashierCounterEntity = _objDALCashierCounter.GetById(id);
return(_objCashierCounterEntity);
}
catch (Exception ex)
{
if (ex is DALException)
{
throw ex;
}
else
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
}
throw new BALException(ex.Message.ToString());
}
}
// GET: /Company/Edit/5
public ActionResult Edit(long?id)
{
try
{
if (Session[SessionVariables.Session_UserInfo] != null)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
POS_CASHIER_COUNTER pos_cashiercounter = _objBALCahierCounter.GetById(id);
if (pos_cashiercounter == null)
{
return(HttpNotFound());
}
BranchList();
return(View(pos_cashiercounter));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
error.Breadcrum = "Home > Cashier Counter > List > Edit";
if (ex is BALException)
{
error.ErrorMsg = ex.Message.ToString() + "from " + ex.TargetSite.DeclaringType.Name + " method in " + ex.TargetSite.Name + " layer";
}
else
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.UI, ExceptionType.Error);
error.ErrorMsg = ex.Message.ToString() + "from " + ex.TargetSite.DeclaringType.Name + " method in " + ex.TargetSite.Name + " layer";
}
return(RedirectToAction("ShowErrorPage", "Master", error));
}
}
