//private void ManageExternalResources(string fileName, string culture)
//{
// string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
// conStr += Server.MapPath("~/common/db/demo.mdb");
// System.Data.OleDb.OleDbConnection srcDB = new System.Data.OleDb.OleDbConnection(conStr);
// srcDB.Open();
// string sql = "Select * From ConceptsReserveFields";
// System.Data.OleDb.OleDbDataAdapter daSrc = new System.Data.OleDb.OleDbDataAdapter(sql, srcDB);
// DataTable oTable = new DataTable();
// daSrc.Fill(oTable);
// srcDB.Close();
// string filePath = "App_LocalResources\\" + fileName;
// ResXResourceReader resxReader = new ResXResourceReader(Server.MapPath(filePath));
// ResXResourceWriter resxWriter = new ResXResourceWriter(Server.MapPath(filePath));
// foreach (DictionaryEntry de in resxReader)
// {
// string key = de.Key.ToString().Replace(".HeadingText", string.Empty);
// DataRow[] RowCol = (oTable.Select("OriginalName='" + key + "'"));
// if (RowCol.Length == 0)
// resxWriter.AddResource(de.Key.ToString(), de.Value.ToString());
// }
// foreach (DataRow dr in oTable.Rows)
// {
// string NewValue = string.Empty;
// switch (culture)
// {
// case "fa-IR":
// NewValue = dr["Fa_Name"].ToString();
// break;
// case "en-US":
// NewValue = dr["En_Name"].ToString();
// break;
// }
// resxWriter.AddResource(dr["OriginalName"].ToString() + ".HeadingText", NewValue);
// }
// resxReader.Close();
// resxWriter.Generate();
// resxWriter.Close();
//}
private void Fill_GridSummaryMonthlyOperation_ManagerMasterMonthlyOperation(LoadState Ls, decimal departmentID, int pageSize, int pageIndex, GridOrderFields Gof, GridOrderFieldType Goft, GridSearchFields Gsf, string SearchTerm, int Month)
{
IList <UnderManagementPerson> UnderManagementPersonnelList = null;
this.InitializeCulture();
switch (Ls)
{
case LoadState.Normal:
if (departmentID == 0)
{
return;
}
UnderManagementPersonnelList = this.MonthlyOperationBusiness.GetUnderManagmentByDepartment(Month, departmentID, pageIndex, pageSize, Gof, Goft);
break;
case LoadState.Search:
UnderManagementPersonnelList = this.MonthlyOperationBusiness.GetUnderManagmentBySearch(Month, SearchTerm, Gsf, pageIndex, pageSize, Gof, Goft);
break;
}
this.GridMonthlyOperationSummary_ManagerMasterMonthlyOperation.DataSource = UnderManagementPersonnelList;
this.GridMonthlyOperationSummary_ManagerMasterMonthlyOperation.DataBind();
}
/// <summary>
/// افراد تحت مدیریت را براساس کلمه جستجوشده برمیگرداند
/// </summary>
/// <param name="searchKey"></param>
/// <param name="searchType"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="orderField"></param>
/// <param name="orderType"></param>
/// <returns></returns>
public IList <UnderManagementPerson> GetUnderManagmentBySearch(int month, string searchKey, GridSearchFields searchType, int pageIndex, int pageSize, GridOrderFields orderField, GridOrderFieldType orderType)
{
try
{
if (InitManager())
{
if (orderField == GridOrderFields.NONE)
{
orderField = GridOrderFields.gridFields_BarCode;
}
IList <UnderManagementPerson> Result = new List <UnderManagementPerson>();
if (searchType == GridSearchFields.PersonName)
{
Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.PersonName, BUser.CurrentUser.Person.ID, 0, searchKey, "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
}
else if (searchType == GridSearchFields.PersonCode)
{
Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.PersonCode, BUser.CurrentUser.Person.ID, 0, "", searchKey, month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
}
else
{
Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.PersonName, BUser.CurrentUser.Person.ID, 0, searchKey, "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
if (Result == null || Result.Count == 0)
{
Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.PersonCode, BUser.CurrentUser.Person.ID, 0, "", searchKey, month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
}
}
foreach (UnderManagementPerson under in Result)
{
#region LoadBasicTraffic
GTS.Clock.Business.BaseInformation.BTraffic trafficBus = new BaseInformation.BTraffic();
IList <BasicTrafficProxy> trafficList = trafficBus.GetDayTraffics(under.PersonId, Utility.ToString(DateTime.Now));
int counter = 1;
foreach (BasicTrafficProxy trafic in trafficList)
{
switch (counter)
{
case 1:
under.FirstEntrance = trafic.TheTime;
break;
case 2:
under.FirstExit = trafic.TheTime;
break;
case 3:
under.SecondEntrance = trafic.TheTime;
break;
case 4:
under.SecondExit = trafic.TheTime;
break;
case 5:
under.ThirdEntrance = trafic.TheTime;
break;
case 6:
under.ThirdExit = trafic.TheTime;
break;
case 7:
under.FourthEntrance = trafic.TheTime;
break;
case 8:
under.FourthExit = trafic.TheTime;
break;
case 9:
under.FifthEntrance = trafic.TheTime;
break;
case 10:
under.FifthExit = trafic.TheTime;
break;
}
counter++;
}
under.LastExit = trafficList.LastOrDefault() != null?trafficList.LastOrDefault().TheTime : "";
#endregion
}
return(Result);
}
else if (InitOperator())
{
decimal oprPrsId = BUser.CurrentUser.Person.ID;
if (orderField == GridOrderFields.NONE)
{
orderField = GridOrderFields.gridFields_BarCode;
}
IList <UnderManagementPerson> Result = new List <UnderManagementPerson>();
if (searchType == GridSearchFields.PersonName)
{
Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.PersonName, oprPrsId, 0, searchKey, "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
}
else if (searchType == GridSearchFields.PersonCode)
{
Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.PersonCode, oprPrsId, 0, "", searchKey, month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
}
else
{
Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.PersonName, oprPrsId, 0, searchKey, "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
if (Result == null || Result.Count == 0)
{
Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.PersonCode, oprPrsId, 0, "", searchKey, month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
}
}
foreach (UnderManagementPerson under in Result)
{
#region LoadBasicTraffic
GTS.Clock.Business.BaseInformation.BTraffic trafficBus = new BaseInformation.BTraffic();
IList <BasicTrafficProxy> trafficList = trafficBus.GetDayTraffics(under.PersonId, Utility.ToString(DateTime.Now));
int counter = 1;
foreach (BasicTrafficProxy trafic in trafficList)
{
switch (counter)
{
case 1:
under.FirstEntrance = trafic.TheTime;
break;
case 2:
under.FirstExit = trafic.TheTime;
break;
case 3:
under.SecondEntrance = trafic.TheTime;
break;
case 4:
under.SecondExit = trafic.TheTime;
break;
case 5:
under.ThirdEntrance = trafic.TheTime;
break;
case 6:
under.ThirdExit = trafic.TheTime;
break;
case 7:
under.FourthEntrance = trafic.TheTime;
break;
case 8:
under.FourthExit = trafic.TheTime;
break;
case 9:
under.FifthEntrance = trafic.TheTime;
break;
case 10:
under.FifthExit = trafic.TheTime;
break;
}
counter++;
}
under.LastExit = trafficList.LastOrDefault() != null?trafficList.LastOrDefault().TheTime : "";
#endregion
}
return(Result);
}
else
{
throw new IllegalServiceAccess(String.Format("این سرویس تنها توسط مدیران قابل استفاده میباشد. شناسه کاربری {0} میباشد", this.Username), ExceptionSrc);
}
}
catch (Exception ex)
{
BaseBusiness <Entity> .LogException(ex, "BWorkedTime", "GetUnderManagmentByDepartment");
throw ex;
}
}
public IList <UnderManagementPerson> GetUnderManagmentOperatorByDepartment(GridSearchFields SearchField, decimal oprPersonId, decimal departmentID, string personName, string personbarCode, int dateRangeOrder, int dateRangeOrderIndex, string CurrentDateTime, GridOrderFields order, GridOrderFieldType orderType, int pageIndex, int pageSize)
{
string orderingType = orderType.ToString();
string orderingField = order.ToString();
return(NHibernateSession.GetNamedQuery("GetUnderManagementOperatorPersonList")
.SetParameter("oprPersonId", oprPersonId)
.SetParameter("departmentId", departmentID)
.SetParameter("searchField", (int)SearchField)
.SetParameter("barcodeParam", personbarCode)
.SetParameter("personNameParam", personName)
.SetParameter("orderByField", orderingField)
.SetParameter("orderType", orderingType)
.SetParameter("dateRangeOrder", dateRangeOrder)
.SetParameter("dateRangeOrderIndex", dateRangeOrderIndex)
.SetParameter("curentDate", CurrentDateTime)
.SetParameter("pageSize", pageSize)
.SetParameter("pageIndex", pageIndex)
.List <UnderManagementPerson>());
}
/// <summary>
/// با دریافت یک گره از درخت تحت مدیریت مدیر اشخاص تحت مدیریت را برمیگرداند
/// این افراد مرتب شده بر اساس فیلد مشخص شده هستند
/// </summary>
/// <param name="departmentID"></param>
/// <returns></returns>
public IList <UnderManagementPerson> GetUnderManagmentByDepartment(int month, decimal departmentID, int pageIndex, int pageSize, GridOrderFields orderField, GridOrderFieldType orderType)
{
try
{
int year = 0;
if (BLanguage.CurrentSystemLanguage == LanguagesName.Parsi)
{
year = Utility.ToPersianDateTime(DateTime.Now).Year;
if (month <= 0)
{
month = Utility.ToPersianDateTime(DateTime.Now).Month;
}
}
else
{
year = DateTime.Now.Year;
if (month <= 0)
{
month = DateTime.Now.Month;
}
}
if (orderField == GridOrderFields.NONE)
{
orderField = GridOrderFields.gridFields_BarCode;
}
if (InitManager())
{
IList <UnderManagementPerson> Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.NONE, BUser.CurrentUser.Person.ID, departmentID, "", "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
foreach (UnderManagementPerson under in Result)
{
#region LoadBasicTraffic
GTS.Clock.Business.BaseInformation.BTraffic trafficBus = new BaseInformation.BTraffic();
IList <BasicTrafficProxy> trafficList = trafficBus.GetDayTraffics(under.PersonId, Utility.ToString(DateTime.Now));
int counter = 1;
foreach (BasicTrafficProxy trafic in trafficList)
{
switch (counter)
{
case 1:
under.FirstEntrance = trafic.TheTime;
break;
case 2:
under.FirstExit = trafic.TheTime;
break;
case 3:
under.SecondEntrance = trafic.TheTime;
break;
case 4:
under.SecondExit = trafic.TheTime;
break;
case 5:
under.ThirdEntrance = trafic.TheTime;
break;
case 6:
under.ThirdExit = trafic.TheTime;
break;
case 7:
under.FourthEntrance = trafic.TheTime;
break;
case 8:
under.FourthExit = trafic.TheTime;
break;
case 9:
under.FifthEntrance = trafic.TheTime;
break;
case 10:
under.FifthExit = trafic.TheTime;
break;
}
counter++;
}
under.LastExit = trafficList.LastOrDefault() != null?trafficList.LastOrDefault().TheTime : "";
#endregion
under.RemainLeaveToYearEnd = this.GetReainLeaveToEndOfYear(under.PersonId, year, month);
under.RemainLeaveToMonthEnd = this.GetReaiLeaveToEndMonth(under.PersonId, year, month);
}
return(Result);
}
else if (InitOperator())
{
IList <UnderManagementPerson> Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.NONE, BUser.CurrentUser.Person.ID, departmentID, "", "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize);
foreach (UnderManagementPerson under in Result)
{
#region LoadBasicTraffic
GTS.Clock.Business.BaseInformation.BTraffic trafficBus = new BaseInformation.BTraffic();
IList <BasicTrafficProxy> trafficList = trafficBus.GetDayTraffics(under.PersonId, Utility.ToString(DateTime.Now));
int counter = 1;
foreach (BasicTrafficProxy trafic in trafficList)
{
switch (counter)
{
case 1:
under.FirstEntrance = trafic.TheTime;
break;
case 2:
under.FirstExit = trafic.TheTime;
break;
case 3:
under.SecondEntrance = trafic.TheTime;
break;
case 4:
under.SecondExit = trafic.TheTime;
break;
case 5:
under.ThirdEntrance = trafic.TheTime;
break;
case 6:
under.ThirdExit = trafic.TheTime;
break;
case 7:
under.FourthEntrance = trafic.TheTime;
break;
case 8:
under.FourthExit = trafic.TheTime;
break;
case 9:
under.FifthEntrance = trafic.TheTime;
break;
case 10:
under.FifthExit = trafic.TheTime;
break;
}
counter++;
}
under.LastExit = trafficList.LastOrDefault() != null?trafficList.LastOrDefault().TheTime : "";
#endregion
under.RemainLeaveToYearEnd = this.GetReainLeaveToEndOfYear(under.PersonId, year, month);
under.RemainLeaveToMonthEnd = this.GetReaiLeaveToEndMonth(under.PersonId, year, month);
}
return(Result);
}
else
{
throw new IllegalServiceAccess(String.Format("این سرویس تنها توسط مدیران قابل استفاده میباشد. شناسه کاربری {0} میباشد", this.Username), ExceptionSrc);
}
}
catch (Exception ex)
{
BaseBusiness <Entity> .LogException(ex, "BWorkedTime", "GetUnderManagmentByDepartment");
throw ex;
}
}
