public int Create(POS_COMPANY CompanyModel)
{
int rowAffected = 0;
try
{
_objCompanyEntity.COMPANY_ID = GetMaxId();
_objCompanyEntity.COMPANY_CODE = GetMaxCode();
_objCompanyEntity.COMPANY_DESC = CompanyModel.COMPANY_DESC;
_objCompanyEntity.LOGO = CompanyModel.LOGO;
_objCompanyEntity.HTTP_HOST_ADDRESS = CompanyModel.HTTP_HOST_ADDRESS;
_objCompanyEntity.NTN_NO = CompanyModel.NTN_NO;
_objCompanyEntity.REGISTEREDBY = CompanyModel.REGISTEREDBY;
_objCompanyEntity.ISPOSTED_FLAG = false;
_objCompanyEntity.ISACTIVE_FLAG = CompanyModel.ISACTIVE_FLAG;
_objCompanyEntity.CREATEDBY = CompanyModel.CREATEDBY;
_objCompanyEntity.CREATEDWHEN = CompanyModel.CREATEDWHEN;
_dbContext.POS_COMPANY.Add(CompanyModel);
rowAffected = _dbContext.SaveChanges();
return(rowAffected);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException(ex.Message.ToString());
}
}
// GET: Preferences/Create
public ActionResult Create()
{
POS_COMPANY tblcmp = db.POS_COMPANY.FirstOrDefault();
if (tblcmp != null)
{
tblcmp.IsMultipleBranch = tblcmp.IsMultipleBranch;
tblcmp.IsWarehouse = tblcmp.IsWarehouse;
tblcmp.IsWarehouseStock = tblcmp.IsWarehouseStock;
tblcmp.IsWarehouseTracking = tblcmp.IsWarehouseTracking;
tblcmp.IsWarehouseShipment = tblcmp.IsWarehouseShipment;
tblcmp.IsVendor = tblcmp.IsVendor;
tblcmp.IsVendorShipment = tblcmp.IsVendorShipment;
tblcmp.IsDisplayTracking = tblcmp.IsDisplayTracking;
tblcmp.IsRFQ = tblcmp.IsRFQ;
tblcmp.IsAccounting = tblcmp.IsAccounting;
tblcmp.IsCashierCounter = tblcmp.IsCashierCounter;
tblcmp.IsPromotion = tblcmp.IsPromotion;
tblcmp.IsPaymentSystem = tblcmp.IsPaymentSystem;
return(View(tblcmp));
}
else
{
return(View(tblcmp));
}
}
public Notify Create(POS_COMPANY CompanyModel)
{
try
{
int rowAffected = _objDALCompany.Create(CompanyModel);
if (rowAffected > 0)
{
objNotify.NotifyMessage = "Record Created Successfully";
}
else
{
objNotify.NotifyMessage = "Company Not Created";
}
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 string GetMaxCode()
{
string code = string.Empty;
int maxCode = 0;
try
{
_objCompanyEntity = _dbContext.POS_COMPANY.OrderByDescending(x => x.COMPANY_CODE).FirstOrDefault();
if (_objCompanyEntity.COMPANY_CODE.ToString() == null)
{
code = "0001";
}
else
{
maxCode = Formatter.SetValidValueToInt(_objCompanyEntity.COMPANY_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 Update(POS_COMPANY CompanyModel)
{
int rowAffected = 0;
POS_COMPANY entity = new POS_COMPANY();
try
{
entity = _dbContext.POS_COMPANY.Find(CompanyModel.COMPANY_ID);
_objCompanyEntity.COMPANY_DESC = CompanyModel.COMPANY_DESC;
_objCompanyEntity.LOGO = CompanyModel.LOGO;
_objCompanyEntity.HTTP_HOST_ADDRESS = CompanyModel.HTTP_HOST_ADDRESS;
_objCompanyEntity.NTN_NO = CompanyModel.NTN_NO;
_objCompanyEntity.REGISTEREDBY = CompanyModel.REGISTEREDBY;
_objCompanyEntity.ISPOSTED_FLAG = false;
_objCompanyEntity.ISACTIVE_FLAG = CompanyModel.ISACTIVE_FLAG;
entity.MODIFIEDBY = CompanyModel.MODIFIEDBY;
entity.MODIFIEDWHEN = CompanyModel.MODIFIEDWHEN;
rowAffected = _dbContext.SaveChanges();
return(rowAffected);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException();
}
}
public ActionResult DeleteConfirmed(long id)
{
POS_COMPANY pOS_COMPANY = db.POS_COMPANY.Find(id);
db.POS_COMPANY.Remove(pOS_COMPANY);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "COMPANY_ID,COMPANY_CODE,COMPANY_DESC,LOGO,HTTP_HOST_ADDRESS,NTN_NO,REGISTEREDBY,ISACTIVE_FLAG,ISPOSTED_FLAG,CREATEDBY,MODIFIEDBY,CREATEDWHEN,MODIFIEDWHEN,IsMultipleBranch,IsWarehouse,IsWarehouseStock,IsWarehouseTracking,IsWarehouseShipment,IsVendor,IsVendorShipment,IsDisplayTracking,IsRFQ,IsAccounting,IsCashierCounter,IsPromotion,IsPaymentSystem")] POS_COMPANY pOS_COMPANY)
{
if (ModelState.IsValid)
{
db.Entry(pOS_COMPANY).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pOS_COMPANY));
}
public ActionResult Edit([Bind(Include = "COMPANY_ID,COMPANY_CODE,COMPANY_DESC,LOGO,HTTP_HOST_ADDRESS,NTN_NO,REGISTEREDBY,ISACTIVE_FLAG,ISPOSTED_FLAG,CREATEDBY,MODIFIEDBY,CREATEDWHEN,MODIFIEDWHEN")] POS_COMPANY pos_company)
{
if (ModelState.IsValid)
{
db.Entry(pos_company).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pos_company));
}
//[ValidateAntiForgeryToken]
public ActionResult Create(POS_COMPANY pOS_COMPANY)
{
try
{
if (ModelState.IsValid)
{
POS_COMPANY tblcmp = db.POS_COMPANY.FirstOrDefault();
if (tblcmp != null)
{
tblcmp.IsMultipleBranch = pOS_COMPANY.IsMultipleBranch;
tblcmp.IsWarehouse = pOS_COMPANY.IsWarehouse;
tblcmp.IsWarehouseStock = pOS_COMPANY.IsWarehouseStock;
tblcmp.IsWarehouseTracking = pOS_COMPANY.IsWarehouseTracking;
tblcmp.IsWarehouseShipment = pOS_COMPANY.IsWarehouseShipment;
tblcmp.IsVendor = pOS_COMPANY.IsVendor;
tblcmp.IsVendorShipment = pOS_COMPANY.IsVendorShipment;
tblcmp.IsDisplayTracking = pOS_COMPANY.IsDisplayTracking;
tblcmp.IsRFQ = pOS_COMPANY.IsRFQ;
tblcmp.IsAccounting = pOS_COMPANY.IsAccounting;
tblcmp.IsCashierCounter = pOS_COMPANY.IsCashierCounter;
tblcmp.IsPromotion = pOS_COMPANY.IsPromotion;
tblcmp.IsPaymentSystem = pOS_COMPANY.IsPaymentSystem;
// Session["FormName"] = "Email Settings";
db.SaveChanges();
}
else
{
pOS_COMPANY.IsMultipleBranch = pOS_COMPANY.IsMultipleBranch;
pOS_COMPANY.IsWarehouse = pOS_COMPANY.IsWarehouse;
pOS_COMPANY.IsWarehouseStock = pOS_COMPANY.IsWarehouseStock;
pOS_COMPANY.IsWarehouseTracking = pOS_COMPANY.IsWarehouseTracking;
pOS_COMPANY.IsWarehouseShipment = pOS_COMPANY.IsWarehouseShipment;
pOS_COMPANY.IsVendor = pOS_COMPANY.IsVendor;
pOS_COMPANY.IsVendorShipment = pOS_COMPANY.IsVendorShipment;
pOS_COMPANY.IsDisplayTracking = pOS_COMPANY.IsDisplayTracking;
pOS_COMPANY.IsRFQ = pOS_COMPANY.IsRFQ;
pOS_COMPANY.IsAccounting = pOS_COMPANY.IsAccounting;
pOS_COMPANY.IsCashierCounter = pOS_COMPANY.IsCashierCounter;
pOS_COMPANY.IsPromotion = pOS_COMPANY.IsPromotion;
pOS_COMPANY.IsPaymentSystem = pOS_COMPANY.IsPaymentSystem;
db.POS_COMPANY.Add(pOS_COMPANY);
db.SaveChanges();
}
return(View(pOS_COMPANY));
}
}
catch (Exception ex)
{
throw ex;
}
return(View(pOS_COMPANY));
}
public POS_COMPANY GetById(long?id)
{
try
{
_objCompanyEntity = _dbContext.POS_COMPANY.Find(id);
return(_objCompanyEntity);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException();
}
}
// GET: Preferences/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
POS_COMPANY pOS_COMPANY = db.POS_COMPANY.Find(id);
if (pOS_COMPANY == null)
{
return(HttpNotFound());
}
return(View(pOS_COMPANY));
}
// GET: /Company/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
POS_COMPANY pos_company = db.POS_COMPANY.Find(id);
if (pos_company == null)
{
return(HttpNotFound());
}
return(View(pos_company));
}
public int Delete(long id)
{
int rowAffected = 0;
try
{
_objCompanyEntity = _dbContext.POS_COMPANY.Find(id);
_dbContext.POS_COMPANY.Remove(_objCompanyEntity);
rowAffected = _dbContext.SaveChanges();
return(rowAffected);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException();
}
}
public POS_COMPANY GetById(long?id)
{
try
{
_objCompanyEntity = _objDALCompany.GetById(id);
return(_objCompanyEntity);
}
catch (Exception ex)
{
if (ex is DALException)
{
throw ex;
}
else
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
}
throw new BALException(ex.Message.ToString());
}
}
public bool IsDisplayTracking()
{
bool flag = false;
try
{
_objCompanyEntity = _dbContext.POS_COMPANY.Where(m => m.IsDisplayTracking == true).FirstOrDefault();
if (_objCompanyEntity.IsDisplayTracking == false)
{
flag = false;
}
else
{
flag = true;
}
return(flag);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException();
}
}
public long GetMaxId()
{
long id = 0;
try
{
_objCompanyEntity = _dbContext.POS_COMPANY.OrderByDescending(x => x.COMPANY_ID).FirstOrDefault();
if (_objCompanyEntity.COMPANY_ID.ToString() == null)
{
id = 1;
}
else
{
id = _objCompanyEntity.COMPANY_ID + 1;
}
return(id);
}
catch (Exception ex)
{
ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error);
throw new DALException();
}
}
