public M_Company SelectCompany(string code)
{
try
{
M_Company objBank = new M_Company();
strquery = @"select * from M_Company where CompCode = '" + code.Trim() + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objBank.Add1 = drType["Add1"].ToString();
objBank.Add2 = drType["Add2"].ToString();
objBank.Add3 = drType["Add3"].ToString();
objBank.CompCode = drType["CompCode"].ToString();
objBank.Datex = DateTime.Parse(drType["Datex"].ToString());
objBank.Descr = drType["Descr"].ToString();
objBank.Emailx = drType["Emailx"].ToString();
objBank.Fax = drType["Fax"].ToString();
objBank.Tpno = drType["Tpno"].ToString();
objBank.Userx = drType["Userx"].ToString();
return(objBank);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
private void SetValues(String Bank)
{
try
{
M_CompanyDL objBankBL = new M_CompanyDL();
M_Company objBank = new M_Company();
if (Bank != "")
{
objBank.CompCode = Bank;
objBank = objBankBL.SelectCompany(Bank);
if (objBank != null)
{
txt_comcode.Text = objBank.CompCode.ToString();
txt_name.Text = objBank.Descr.ToString();
txt_add1.Text = objBank.Add1.ToString();
txt_add2.Text = objBank.Add2.ToString();
txt_add3.Text = objBank.Add3.ToString();
txt_email.Text = objBank.Emailx.ToString();
txt_fax.Text = objBank.Fax.ToString();
txt_tp.Text = objBank.Tpno.ToString();
formMode = 3;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetList(M_Company objCompany)
{
List <M_Company> ObjList = new List <M_Company>();
try
{
var vList = _blCompany.GetList(objCompany);
if (vList.Count > 0)
{
foreach (var item in vList)
{
var vObjItemUser = new M_Company()
{
Id = item.Id,
Name = item.Name,
Phone = item.Phone,
Email = item.Email,
Address = item.Address,
CreatedBy = item.CreatedBy,
CreatedDate = item.CreatedDate,
ModifyBy = item.ModifyBy,
ModifyDate = item.ModifyDate
};
ObjList.Add(vObjItemUser);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(ObjList, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(M_Company objCompany)
{
try
{
if (ModelState.IsValid)
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(objCompany.Id)))
{
var vObj = _blCompany.GetById(objCompany.Id);
if (vObj != null)
{
vObj.Name = objCompany.Name;
vObj.Phone = objCompany.Phone;
vObj.Email = objCompany.Email;
vObj.Address = objCompany.Address;
vObj.ModifyDate = DateTime.Now;
vObj.ModifyBy = _objAuthentication.UserName;
_blCompany.Update(vObj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("Index", "Company"));
}
//public int DeleteCompany(M_Company comp)
//{
// using (var context = new MasterDbContext(contextOptions))
// {
// using (var transaction = context.Database.BeginTransaction())
// {
// try
// {
// MySqlParameter[] sqlParams = new MySqlParameter[] {
// new MySqlParameter("strId", comp.Id),
// new MySqlParameter("strDelete_By", comp.Updated_By)
// };
// //Output Parameter no need to define. @`strId`
// int rowaffected = context.Database.ExecuteSqlCommand("call sp_company_delete( ?, ?)", parameters: sqlParams);
// transaction.Commit();
// return rowaffected;
// }
// catch (Exception ex)
// {
// transaction.Rollback();
// throw ex;
// }
// }
// }
//}
public async Task <ResultObject> DeleteCompany(M_Company comp)
{
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = comp
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strId", comp.Id),
new MySqlParameter("strDelete_By", comp.Updated_By)
};
//Output Parameter no need to define. @`strId`
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_company_delete( ?, ?)", parameters : sqlParams);
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public Boolean SaveBankSP(M_Company m_Company, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "Company_Save";
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = m_Company.CompCode;
scom.Parameters.Add("@Descr", SqlDbType.VarChar, 50).Value = m_Company.Descr;
scom.Parameters.Add("@Add1", SqlDbType.VarChar, 50).Value = m_Company.Add1;
scom.Parameters.Add("@Add2", SqlDbType.VarChar, 50).Value = m_Company.Add2;
scom.Parameters.Add("@Add3", SqlDbType.VarChar, 50).Value = m_Company.Add3;
scom.Parameters.Add("@Fax", SqlDbType.VarChar, 50).Value = m_Company.Fax;
scom.Parameters.Add("@Emailx", SqlDbType.VarChar, 50).Value = m_Company.Emailx;
scom.Parameters.Add("@Tpno", SqlDbType.VarChar, 20).Value = m_Company.Tpno;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = m_Company.Userx;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_Company.Datex;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public static bool Update(CompanyViewModel entity)
{
bool result = true;
try
{
using (var db = new MarComContext())
{
if (entity.Id == 0)
{
M_Company comp = new M_Company();
comp.Code = entity.Code;
comp.Name = entity.Name;
comp.Address = entity.Address;
comp.Email = entity.Email;
comp.Phone = entity.Phone;
comp.Is_Delete = entity.Is_Delete;
comp.Create_By = "Admin";
comp.Create_Date = DateTime.Now;
db.M_Company.Add(comp);
db.SaveChanges();
}
else
{
M_Company comp = db.M_Company.Where(c => c.Id == entity.Id).FirstOrDefault();
if (comp != null)
{
comp.Code = entity.Code;
comp.Name = entity.Name;
comp.Address = entity.Address;
comp.Email = entity.Email;
comp.Phone = entity.Phone;
comp.Update_By = "Admin";
comp.Update_Date = DateTime.Now;
db.SaveChanges();
}
}
}
}
catch (Exception)
{
result = false;
}
return(result);
}
public M_Company Delete(M_Company ObjCompany)
{
try
{
using (_objUnitOfWork = new UnitOfWork())
{
_objUnitOfWork._M_Company_Repository.Delete(ObjCompany.Id);
_objUnitOfWork.Save();
}
}
catch (Exception ex)
{
throw ex;
}
return(ObjCompany);
}
public M_CompanyModel CheckLogin(M_CompanyModel mcmodel)
{
TOSEntities ent = new TOSEntities();
M_Company mc = ent.M_Company.Where(m => m.CompanyCD == mcmodel.CompanyCD && m.Password == mcmodel.Password).SingleOrDefault();
if (mc == null)
{
return(null);
}
else
{
mcmodel.CompanyName = mc.CompanyName;
mcmodel.UserRole = mc.UserRole;
return(mcmodel);
}
}
public M_Company GetById(Guid UserId)
{
var ObjCompany = new M_Company();
try
{
using (_objUnitOfWork = new UnitOfWork())
{
ObjCompany = _objUnitOfWork._M_Company_Repository.GetById(UserId);
}
}
catch (Exception ex)
{
throw ex;
}
return(ObjCompany);
}
public M_Company GetFirstOrDefault(M_Company ObjCompany)
{
var ReturnCompanyObj = new M_Company();
try
{
using (_objUnitOfWork = new UnitOfWork())
{
ReturnCompanyObj = _objUnitOfWork._M_Company_Repository.GetFirstOrDefault(x => x.Name == ObjCompany.Name);
}
}
catch (Exception ex)
{
throw ex;
}
return(ReturnCompanyObj);
}
//public int UpdateCompany(M_Company comp)
//{
// using (var context = new MasterDbContext(contextOptions))
// {
// using (var transaction = context.Database.BeginTransaction())
// {
// try
// {
// context.Entry(comp).State = EntityState.Modified;
// MySqlParameter[] sqlParams = new MySqlParameter[] {
// new MySqlParameter("strId", comp.Id),
// new MySqlParameter("strCompanyCode", comp.CompanyCode),
// new MySqlParameter("strCompanyName", comp.CompanyName),
// new MySqlParameter("strCompanyLogoPath", comp.CompanyLogoPath),
// new MySqlParameter("strAddressL1", comp.AddressL1),
// new MySqlParameter("strAddressL2", comp.AddressL2),
// new MySqlParameter("strAddressL3", comp.AddressL3),
// new MySqlParameter("strAddressL4", comp.AddressL4),
// new MySqlParameter("strTelephone", comp.Telephone),
// new MySqlParameter("strFax", comp.Fax),
// new MySqlParameter("strCompanyTaxId", comp.CompanyTaxId),
// new MySqlParameter("strIs_Active", comp.Is_Active),
// new MySqlParameter("strUpdated_By", comp.Updated_By)
// };
// //Output Parameter no need to define. @`strId`
// int rowaffected = context.Database.ExecuteSqlCommand("call sp_company_update(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", parameters: sqlParams);
// transaction.Commit();
// return rowaffected;
// }
// catch (Exception ex)
// {
// transaction.Rollback();
// throw ex;
// }
// }
// }
//}
public async Task <ResultObject> UpdateCompany(M_Company comp)
{
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = comp
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
context.Entry(comp).State = EntityState.Modified;
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strId", comp.Id),
new MySqlParameter("strCompanyCode", comp.CompanyCode),
new MySqlParameter("strCompanyName", comp.CompanyName),
new MySqlParameter("strCompanyLogoPath", comp.CompanyLogoPath),
new MySqlParameter("strAddressL1", comp.AddressL1),
new MySqlParameter("strAddressL2", comp.AddressL2),
new MySqlParameter("strAddressL3", comp.AddressL3),
new MySqlParameter("strAddressL4", comp.AddressL4),
new MySqlParameter("strTelephone", comp.Telephone),
new MySqlParameter("strFax", comp.Fax),
new MySqlParameter("strCompanyTaxId", comp.CompanyTaxId),
new MySqlParameter("strIs_Active", comp.Is_Active),
new MySqlParameter("strUpdated_By", comp.Updated_By)
};
//Output Parameter no need to define. @`strId`
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_company_update(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", parameters : sqlParams);
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
//public int InsertCompany(ref M_Company comp)
//{
// using (var context = new MasterDbContext(contextOptions))
// {
// using (var transaction = context.Database.BeginTransaction())
// {
// try
// {
// MySqlParameter[] sqlParams = new MySqlParameter[] {
// new MySqlParameter("strCompanyCode", comp.CompanyCode),
// new MySqlParameter("strCompanyName", comp.CompanyName),
// new MySqlParameter("strCompanyLogoPath", comp.CompanyLogoPath),
// new MySqlParameter("strAddressL1", comp.AddressL1),
// new MySqlParameter("strAddressL2", comp.AddressL2),
// new MySqlParameter("strAddressL3", comp.AddressL3),
// new MySqlParameter("strAddressL4", comp.AddressL4),
// new MySqlParameter("strTelephone", comp.Telephone),
// new MySqlParameter("strFax", comp.Fax),
// new MySqlParameter("strCompanyTaxId", comp.CompanyTaxId),
// new MySqlParameter("strIs_Active", comp.Is_Active),
// new MySqlParameter("strCreated_By", comp.Created_By)
// };
// //Output Parameter no need to define. @`strId`
// int rowaffected = context.Database.ExecuteSqlCommand("call sp_company_insert(@`strId`, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", parameters: sqlParams);
// var newComp = context.Companies.FromSql("SELECT * FROM m_company WHERE Id = @`strId`;").ToListAsync();
// comp = newComp.Result[0];
// transaction.Commit();
// return rowaffected;
// }
// catch (Exception ex)
// {
// transaction.Rollback();
// throw ex;
// }
// }
// }
//}
public async Task <ResultObject> InsertCompany(M_Company comp)
{
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = comp
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strCompanyCode", comp.CompanyCode),
new MySqlParameter("strCompanyName", comp.CompanyName),
new MySqlParameter("strCompanyLogoPath", comp.CompanyLogoPath),
new MySqlParameter("strAddressL1", comp.AddressL1),
new MySqlParameter("strAddressL2", comp.AddressL2),
new MySqlParameter("strAddressL3", comp.AddressL3),
new MySqlParameter("strAddressL4", comp.AddressL4),
new MySqlParameter("strTelephone", comp.Telephone),
new MySqlParameter("strFax", comp.Fax),
new MySqlParameter("strCompanyTaxId", comp.CompanyTaxId),
new MySqlParameter("strIs_Active", comp.Is_Active),
new MySqlParameter("strCreated_By", comp.Created_By)
};
//Output Parameter no need to define. @`strId`
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_company_insert(@`strId`, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", parameters : sqlParams);
var newComp = context.Companies.FromSql("SELECT * FROM m_company WHERE Id = @`strId`;").ToListAsync();
resultObj.ObjectValue = newComp.Result[0];
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public ActionResult Edit(string Id)
{
M_Company vModel = new M_Company();
if (!string.IsNullOrWhiteSpace(Id))
{
var vDetails = _blCompany.GetById(new Guid(Id));
if (vDetails != null)
{
vModel.Id = vDetails.Id;
vModel.Name = vDetails.Name;
vModel.Phone = vDetails.Phone;
vModel.Email = vDetails.Email;
vModel.Address = vDetails.Address;
}
}
return(View(vModel));
}
public ActionResult Create(M_Company objCompany)
{
try
{
bool bAnyError = false;
if (ModelState.IsValid)
{
var vNameExists = _blCompany.GetFirstOrDefault(objCompany);
if (vNameExists != null)
{
ViewBag.ErrorMsg = "Company Name alreay exists in our system";
bAnyError = true;
}
if (bAnyError == false)
{
M_Company _Obj_M_Company = new M_Company()
{
Id = Guid.NewGuid(),
Name = objCompany.Name,
Phone = objCompany.Phone,
Email = objCompany.Email,
Address = objCompany.Address,
CreatedBy = _objAuthentication.UserName,
CreatedDate = DateTime.Now
};
var vReturnObj = _blCompany.Create(_Obj_M_Company);
}
}
else
{
bAnyError = true;
}
if (bAnyError)
{
return(View(objCompany));
}
return(RedirectToAction("Index", "Company"));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Delete(M_Company objCompany)
{
try
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(objCompany.Id)))
{
var vObj = _blCompany.GetById(objCompany.Id);
if (vObj != null)
{
_blCompany.Delete(objCompany);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(objCompany));
}
public List <M_Company> GetList(M_Company ObjCompany)
{
var ObjList = new List <M_Company>();
try
{
using (_objUnitOfWork = new UnitOfWork())
{
var queryObjList = _objUnitOfWork._M_Company_Repository.Query();
if (!string.IsNullOrWhiteSpace(ObjCompany.Name))
{
queryObjList = queryObjList.Where(x => x.Name.Contains(ObjCompany.Name));
}
ObjList = queryObjList.OrderByDescending(x => x.CreatedDate).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(ObjList);
}
public static bool Delete(int id)
{
bool result = true;
try
{
using (var db = new MarComContext())
{
M_Company comp = db.M_Company.Where(c => c.Id == id).FirstOrDefault();
if (comp != null)
{
comp.Is_Delete = true;
db.SaveChanges();
}
}
}
catch (Exception)
{
throw;
}
return(result);
}
private void performButtons(xEnums.PerformanceType xenum)
{
switch (xenum)
{
case xEnums.PerformanceType.View:
if (ActiveControl.Name.Trim() == txt_comcode.Name.Trim())
{
int length = Convert.ToInt32(ConfigurationManager.AppSettings["BankFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["BankSQL"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["BankField" + m + ""].ToString();
}
frmU_Search find = new frmU_Search(strSQL, strSearchField, this);
find.ShowDialog(this);
}
break;
case xEnums.PerformanceType.New:
FunctionButtonStatus(xEnums.PerformanceType.New);
formMode = 1;
txt_comcode.Focus();
break;
case xEnums.PerformanceType.Edit:
FunctionButtonStatus(xEnums.PerformanceType.Edit);
formMode = 3;
txt_name.Focus();
break;
case xEnums.PerformanceType.Save:
try
{
if (formMode == 1)
{
if (M_CompanyDL.ExistingBank(txt_comcode.Text.Trim()))
{
UserDefineMessages.ShowMsg("The company code you have entered already exists!", UserDefineMessages.Msg_Warning);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_Company objbank = new M_Company();
objbank.CompCode = txt_comcode.Text.Trim();
objbank.Descr = txt_name.Text.Trim().ToUpper();
objbank.Add1 = txt_add1.Text.Trim();
objbank.Add2 = txt_add2.Text.Trim();
objbank.Add3 = txt_add3.Text.Trim();
objbank.Datex = DateTime.Now;
objbank.Emailx = txt_email.Text.Trim();
objbank.Fax = txt_fax.Text.Trim();
objbank.Tpno = txt_tp.Text.Trim();
objbank.Userx = commonFunctions.Loginuser;
M_CompanyDL bal = new M_CompanyDL();
bal.SaveBankSP(objbank, 1);
GetData();
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
}
else if (formMode == 3)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_Company objbank = new M_Company();
objbank.CompCode = txt_comcode.Text.Trim();
objbank.Descr = txt_name.Text.Trim().ToUpper();
objbank.Add1 = txt_add1.Text.Trim();
objbank.Add2 = txt_add2.Text.Trim();
objbank.Add3 = txt_add3.Text.Trim();
objbank.Datex = DateTime.Now;
objbank.Emailx = txt_email.Text.Trim();
objbank.Fax = txt_fax.Text.Trim();
objbank.Tpno = txt_tp.Text.Trim();
objbank.Userx = commonFunctions.Loginuser;
M_CompanyDL bal = new M_CompanyDL();
bal.SaveBankSP(objbank, 3);
GetData();
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
}
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on loading data", 1);
}
break;
case xEnums.PerformanceType.Cancel:
FunctionButtonStatus(xEnums.PerformanceType.Default);
break;
case xEnums.PerformanceType.Print:
UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information);
break;
}
}
public static ResultResponse Update(CompanyViewModel entity)
{
ResultResponse result = new ResultResponse();
try
{
using (var db = new MarComContext())
{
if (entity.Id == 0)
{
M_Company comp = new M_Company();
bool nameExists = db.M_Company.Any(nm => nm.Name.Equals(entity.Name));
if (nameExists)
{
result.Success = false;
result.Message = "Company with name " + entity.Name + " Already Exist!";
}
else
{
comp.Code = entity.Code;
comp.Name = entity.Name;
comp.Address = entity.Address;
comp.Email = entity.Email;
comp.Phone = entity.Phone;
comp.Is_Delete = entity.Is_Delete;
comp.Create_By = entity.Create_By;
comp.Create_Date = DateTime.Now;
db.M_Company.Add(comp);
db.SaveChanges();
result.Message = "Data Saved! Company has been add with code " + entity.Code;
}
}
else
{
M_Company comp = db.M_Company.Where(c => c.Id == entity.Id).FirstOrDefault();
if (comp != null)
{
bool nameExists = db.M_Company.Any(nm => nm.Name.Equals(entity.Name) && nm.Code != entity.Code);
if (nameExists)
{
result.Message = "Company with name " + entity.Name + " Already Exist!";
}
else
{
comp.Code = entity.Code;
comp.Name = entity.Name;
comp.Address = entity.Address;
comp.Email = entity.Email;
comp.Phone = entity.Phone;
comp.Update_By = entity.Update_By;
comp.Update_Date = DateTime.Now;
db.SaveChanges();
result.Message = "Data Update! Company with code " + entity.Code + " has been Updated";
}
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
