public List <SelectListItem> GetCompanyForGroupDropDown()
{
List <SelectListItem> lstRole = new List <SelectListItem>();
try
{
using (this.objDataContext = new CompanyDataContext(Functions.StrConnection))
{
lstRole.Add(new SelectListItem {
Text = "--Select--", Value = string.Empty
});
List <GetCompanyListForGroupResult> lstCompanyResult = this.objDataContext.GetCompanyListForGroup(mySession.Current.UserId, Common.Enum.USER_ADMIN_ROLES.SYSADMIN.GetHashCode(), Common.Enum.USER_ADMIN_ROLES.ADMIN.GetHashCode()).ToList();
if (lstCompanyResult != null && lstCompanyResult.Count > 0)
{
foreach (var item in lstCompanyResult)
{
lstRole.Add(new SelectListItem {
Text = item.CompanyName, Value = item.Id.ToString()
});
}
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId);
}
return(lstRole);
}
public ClsCompany GetCompanyByCompanyId(long lgCompanyId)
{
ClsCompany objClsCompany = new ClsCompany();
try
{
using (this.objDataContext = new CompanyDataContext(Functions.StrConnection))
{
GetCompanyByIdResult item = this.objDataContext.GetCompanyById(lgCompanyId).FirstOrDefault();
if (item != null)
{
objClsCompany.lgId = item.Id;
objClsCompany.strShortName = item.ShortName;
objClsCompany.strFullName = item.FullName;
objClsCompany.strAddress1 = item.Address1;
objClsCompany.strAddress2 = item.Address2;
objClsCompany.strAddress3 = item.Address3;
objClsCompany.intVat = item.Vat;
objClsCompany.strEmail = item.Email;
objClsCompany.strPerson = item.Person;
objClsCompany.strContact = item.Contact;
objClsCompany.strPhone = item.Phone;
objClsCompany.hdnstrAdminUserIds = item.AdminUserIds;
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Company, mySession.Current.UserId);
}
return(objClsCompany);
}
public List <GetCompanyByUserResult> GetCompanyByUser(long lgUserId, int inRow, int inPage, string strSearch, string strSort)
{
try
{
using (this.objDataContext = new CompanyDataContext(Functions.StrConnection))
{
return(this.objDataContext.GetCompanyByUser(inRow, inPage, strSearch, strSort, lgUserId).ToList());
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Company, mySession.Current.UserId);
return(null);
}
}
public List <SearchCompanyResult> SearchCompany(int inRow, int inPage, string strSearch, string strSort)
{
try
{
using (this.objDataContext = new CompanyDataContext(Functions.StrConnection))
{
int SysAdminRoleID = Common.Enum.USER_ADMIN_ROLES.SYSADMIN.GetHashCode();
int AdminRoleID = Common.Enum.USER_ADMIN_ROLES.ADMIN.GetHashCode();
return(this.objDataContext.SearchCompany(inRow, inPage, strSearch, strSort, mySession.Current.UserId, mySession.Current.RoleId, SysAdminRoleID, AdminRoleID).ToList());
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Company, mySession.Current.UserId);
return(null);
}
}
public bool IsCompanyExists(long lgCompanyId, string ShortName)
{
try
{
using (this.objDataContext = new CompanyDataContext(Functions.StrConnection))
{
if (this.objDataContext.Companies.Where(x => x.Id != lgCompanyId && x.ShortName == ShortName && x.IsDeleted.Trim() != "1").Count() > 0)
{
return(true);
}
return(false);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Company, mySession.Current.UserId);
return(false);
}
}
public DeleteCompanyResult DeleteCompany(string strCompanyId, long lgDeletedBy)
{
try
{
using (this.objDataContext = new CompanyDataContext(Functions.StrConnection))
{
DeleteCompanyResult result = this.objDataContext.DeleteCompany(strCompanyId, lgDeletedBy, PageMaster.Company, PageMaster.User).FirstOrDefault();
if (result == null)
{
result = new DeleteCompanyResult();
}
return(result);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Company, mySession.Current.UserId);
return(null);
}
}
public List <SelectListItem> GetCompanyForDropDown(long?CompanyId)
{
List <SelectListItem> lstRole = new List <SelectListItem>();
try
{
using (this.objDataContext = new CompanyDataContext(Functions.StrConnection))
{
lstRole.Add(new SelectListItem {
Text = "--Select--", Value = string.Empty
});
List <GetCompanyAllResult> lstCompanyResult = this.objDataContext.GetCompanyAll(mySession.Current.UserId, Common.Enum.USER_ADMIN_ROLES.SYSADMIN.GetHashCode()).ToList();
if (lstCompanyResult != null && lstCompanyResult.Count > 0)
{
if (CompanyId == 0 || CompanyId == null)
{
lstCompanyResult = lstCompanyResult.ToList();
}
else
{
lstCompanyResult = lstCompanyResult.Where(x => x.Id == CompanyId).ToList();
}
foreach (var item in lstCompanyResult)
{
lstRole.Add(new SelectListItem {
Text = item.ShortName + " (" + item.FullName + ")", Value = item.Id.ToString()
});
}
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId);
}
return(lstRole);
}
public long SaveCompany(ClsCompany objSave)
{
try
{
using (this.objDataContext = new CompanyDataContext(Functions.StrConnection))
{
var result = this.objDataContext.InsertOrUpdateCompany(objSave.lgId, objSave.strShortName, objSave.strFullName, objSave.strAddress1, objSave.strAddress2, objSave.strAddress3, objSave.intVat, objSave.strEmail, objSave.strPerson, objSave.strContact, objSave.strPhone, objSave.strAdminUserIds, mySession.Current.UserId, PageMaster.Company).FirstOrDefault();
if (result != null)
{
return(result.InsertedId);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Company, mySession.Current.UserId);
return(0);
}
}
