public JsonResult GetEntityAndUserType()
{
try
{
List <object> lstCat = new List <object>();
List <object> lstUserType = new List <object>();
BL_DCRHeader _objHead = new BL_DCRHeader();
BLMaster _objMast = new BLMaster();
lstCat = _objHead.GetCategory(_objCurr.GetCompanyCode());
lstUserType = _objMast.GetUserType(_objCurr.GetCompanyCode());
List <JsonResult> lst = new List <JsonResult> {
Json(lstCat, JsonRequestBehavior.AllowGet), Json(lstUserType, JsonRequestBehavior.AllowGet)
};
return(Json(lst, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
return(null);
}
}
/// <summary>
/// Insert and Update
/// </summary>
/// <param name="ExpenseEntityName"></param>
/// <param name="EffectiveFrom"></param>
/// <param name="EffectiveTo"></param>
/// <param name="ExpenseEntityCodeval"></param>
/// <param name="Mode"></param>
/// <returns></returns>
public int InsertandUpdateTheExpenseEntityMaster(string ExpenseEntityName, string EffectiveFrom, string EffectiveTo, string ExpenseEntityCodeval, string Mode)
{
string companyCode = _objcurrentInfo.GetCompanyCode();
try
{
string data = string.Empty;
BLMaster Master = new BLMaster();
if (Mode.ToUpper() == "I") //Insert Data
{
string ExpenseEntityCode = _objData.GetMaxCode(_objcurrentInfo.GetCompanyCode(), "tbl_SFA_Expense_Entity_Master", "Expense_Entity_Code", "EEC");
string status = "1";
int InsertExpenseEntityMaster = Master.InsertExpenseEntityMaster(companyCode, ExpenseEntityCode, ExpenseEntityName, EffectiveFrom, EffectiveTo, status, _objcurrentInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"));
return(InsertExpenseEntityMaster);
}
else
{
int UpdateExpenseEntityMaster = Master.UpdateExpenseEntityMaster(companyCode, ExpenseEntityCodeval, ExpenseEntityName, EffectiveFrom, EffectiveTo, _objcurrentInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"));
return(UpdateExpenseEntityMaster);
}
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:ExpenseEntityName", ExpenseEntityName);
dicContext.Add("Filter:ExpenseEntityCodeval", ExpenseEntityCodeval);
dicContext.Add("Filter:EffectiveFrom", EffectiveFrom);
dicContext.Add("Filter:EffectiveTo", EffectiveTo);
dicContext.Add("Filter:Mode", Mode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(3);
}
}
public int SaveExtendSFC(int distance_Fare_Code, int sfc_Version_No, DateTime dcr_Date, string remark, int sfc_Extend_Count)
{
BLMaster objMaster = new BLMaster();
_objCurrentInfo = new CurrentInfo();
return(objMaster.SaveExtendSFC(distance_Fare_Code, sfc_Version_No, dcr_Date, _objcurrentInfo.GetCompanyCode(), remark, _objcurrentInfo.GetUserCode(), sfc_Extend_Count));
}
/// <summary>
/// Used to get the count of Existing SFC record for same region
/// </summary>
/// <param name="regionCode"></param>
/// <param name="fromPlace"></param>
/// <param name="toPlace"></param>
/// <param name="categoryName"></param>
/// <param name="travelMode"></param>
/// <returns></returns>
public JsonResult CheckExistingSFCforRegion(string regionCode, string fromPlace, string toPlace, string categoryName, string travelMode)
{
string message = string.Empty;
Dictionary <string, int> dicTravleModeCount = new Dictionary <string, int>();
try
{
BLMaster _objDAL = new BLMaster();
CurrentInfo _objCurrentInfo = new CurrentInfo();
dicTravleModeCount = _objDAL.GetExistingSFCCount(_objCurrentInfo.GetCompanyCode(), regionCode, fromPlace, toPlace, categoryName, travelMode);
return(Json(dicTravleModeCount));
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("regionCode", regionCode);
dicContext.Add("fromPlace", fromPlace);
dicContext.Add("toPlace", toPlace);
dicContext.Add("categoryName", categoryName);
dicContext.Add("travelMode", travelMode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
throw ex;
}
}
/// <summary>
/// Insert and Update
/// </summary>
/// <param name="activityName"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="Mode"></param>
/// <param name="updateActivityCode"></param>
/// <returns></returns>
public int InsertActivityMaster(string activityName, string startDate, string endDate, string Mode, string updateActivityCode)
{
string companyCode = _objcurrentInfo.GetCompanyCode();
string UpdatedBy = _objcurrentInfo.GetUserCode();
try
{
string data = string.Empty;
BLMaster Master = new BLMaster();
if (Mode.ToUpper() == "I") // Insert Data
{
string ActivityCode = _objData.GetMaxCode(_objcurrentInfo.GetCompanyCode(), "tbl_SFA_Activity_Master", "Activity_Code", "ATY");
string status = "1";
int InsertActivityMaster = Master.InsertActivityMaster(companyCode, activityName, startDate, endDate, status, ActivityCode, _objcurrentInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"));
return(InsertActivityMaster);
}
else
{
int UpdateActivityMaster = Master.UpdateActivityMaster(companyCode, activityName, startDate, endDate, updateActivityCode, _objcurrentInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"));
return(UpdateActivityMaster);
}
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:activityName", activityName);
dicContext.Add("Filter:startDate", startDate);
dicContext.Add("Filter:endDate", endDate);
dicContext.Add("Filter:Mode", Mode);
dicContext.Add("Filter:updateActivityCode", updateActivityCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(0);
}
}
/// <summary>
/// DownLoad The ActivityMasterDetails into Excel
/// </summary>
public void PutActivityMasterIntoExcel()
{
string error = string.Empty;
StringBuilder sb = new StringBuilder();
try
{
string companyCode = _objcurrentInfo.GetCompanyCode();
DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload();
DataControl.Abstraction.IFileProvider objProvider = new DataControl.Impl.FileSystemProvider();
BLMaster Master = new BLMaster();
DataSet dsActivityMaster = new DataSet();
dsActivityMaster = Master.GetLeaveTypeDetails(companyCode);
//dsc
sb.Append("<table WIDTH='75%' id='tblsummary' class='table table-striped'>");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:#428bca;'>");
sb.Append("<td>Activity Name</td>");
sb.Append("<td>Start Date</td>");
sb.Append("<td>End Date</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("<tbody>");
//
if (dsActivityMaster != null && dsActivityMaster.Tables[0] != null && dsActivityMaster.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsActivityMaster.Tables[0].Rows.Count; i++)
{
sb.Append("<td id='Activity_Name" + i + "'style='text-align:left;'>" + dsActivityMaster.Tables[0].Rows[i]["Activity_Name"] + "</td>");
sb.Append("<td id='Start_Date" + i + " 'style='text-align:left;'>" + dsActivityMaster.Tables[0].Rows[i]["Start_Date"] + "</td>");
sb.Append("<td id='End_Date" + i + " ' style='text-align:left;'>" + dsActivityMaster.Tables[0].Rows[i]["End_Date"] + "</td>");
sb.Append("<td id='Row_Status" + i + " 'style='text-align:left;'>" + dsActivityMaster.Tables[0].Rows[i]["Row_Status"] + "</td></tr>");
}
}
else
{
sb.Append("<tr><td>No records To Display</td></tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider();
DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload();
string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
string userName = _objcurrentInfo.GetUserName();
string subdomainName = System.Web.HttpContext.Current.Request.Url.DnsSafeHost;;
string fileName = "ActivityMaster" + " - " + subdomainName + " - " + userName + ".xls";
string blobUrl = objAzureBlob.AzureBlobUploadText(sb.ToString(), accKey, fileName, "bulkdatasvc");
objFileDownload.DownloadFile(blobUrl, fileName, out error);
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
}
}
public StringBuilder GetInwardExcelDataUserBased(string users_Json, string product_Json, string product_type_name, string division_name)
{
try
{
CreateFileName(product_type_name, division_name);
string company_code = _objCurrentInfo.GetCompanyCode();
string[] hiddenColumns = new string[] { };
string[] editableColumnNames = new string[] { };
string[] hiddenColumnNames = new string[] { };
_objExcelConverter = new ExcelFactory();
BLMaster objBlMaster = new BLMaster();
DataSet dsInwardExcelData = new DataSet();
dsInwardExcelData = objBlMaster.GetInwardExcelDataUserBased(company_code, users_Json, product_Json);
if (dsInwardExcelData.Tables != null && dsInwardExcelData.Tables[0].Rows != null && dsInwardExcelData.Tables[0].Rows.Count > 0)
{
dsInwardExcelData.Tables[0].Columns.Add("Quantity", typeof(string));
DataRowCollection dr = dsInwardExcelData.Tables[0].Rows;
DataColumnCollection dc = dsInwardExcelData.Tables[0].Columns;
_objExcelConverter.DataSetToExcel(DOWNLOAD_PATH_KEY_NAME, _fileNameString.ToString(), dsInwardExcelData, hiddenColumnNames, hiddenColumns, false, editableColumnNames);
}
else
{
StringBuilder str = new StringBuilder("No Data Found.");
return(str);
}
StringBuilder MasterfilenameStrings = GetInwardLookupValuesExcel();
return(_fileNameString.Append("^").Append(MasterfilenameStrings));
}
catch (Exception ex)
{
return(_fileNameString.Append(ex.Message));
}
}
/// <summary>
/// Insert User ProductMapping
/// </summary>
/// <param name="userCodes"></param>
/// <param name="productCodes"></param>
/// <returns></returns>
public string InsertUserProductMapping(string userCodes, string productCodes)
{
int result = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
string companyCode = _objcurrentInfo.GetCompanyCode();
BLMaster _objMaster = new BLMaster();
StringBuilder strBuild = new StringBuilder();
string currentDate = DateTime.Now.ToString("yyyy-MM-dd");
try
{
result = _objMaster.InsertUserProduct(companyCode, userCodes, productCodes, currentDate);
if (result > 0)
{
strBuild.Append("User Product Mapped Sucessfully.");
}
else
{
strBuild.Append("This User Product Already Mapped");
}
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("userCodes", userCodes);
dicContext.Add("productCodes", productCodes);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(null);
}
return(strBuild.ToString());
}
/// <summary>
/// Insert , Update , Change Status for Status Cycle Mapping
/// </summary>
/// <param name="cycleCode"></param>
/// <param name="cycleName"></param>
/// <param name="statusCode"></param>
/// <param name="statusName"></param>
/// <param name="description"></param>
/// <param name="statusOwnerType"></param>
/// <param name="orderNo"></param>
/// <param name="moveOrder"></param>
/// <param name="mode"></param>
/// <param name="oCycleCode"></param>
/// <param name="oStatusCode"></param>
/// <param name="recordStatus"></param>
/// <returns></returns>
public int InsertStatusCycleMapping(string cycleCode, string cycleName, string statusCode, string statusName, string description, string statusOwnerType, int orderNo, string moveOrder, string mode, string oCycleCode, string oStatusCode, int recordStatus)
{
try
{
string companyCode = _objcurrentInfo.GetCompanyCode();
string userName = _objcurrentInfo.GetUserName();
string dateTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
BLMaster objBlMaster = new BLMaster();
return(objBlMaster.InsertStatusCycleMapping(companyCode, cycleCode, cycleName, statusCode, statusName, description, statusOwnerType, orderNo, moveOrder, mode, oCycleCode, oStatusCode, recordStatus, userName, dateTime, userName, dateTime));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
dicObj.Add("cycleCode", cycleCode);
dicObj.Add("cycleName", cycleName);
dicObj.Add("statusCode", statusCode);
dicObj.Add("statusName", statusName);
dicObj.Add("description", description);
dicObj.Add("statusOwnerType", statusOwnerType);
dicObj.Add("orderNo", orderNo.ToString());
dicObj.Add("moveOrder", moveOrder);
dicObj.Add("mode", mode);
dicObj.Add("oCycleCode", oCycleCode);
dicObj.Add("oStatusCode", oStatusCode);
dicObj.Add("recordStatus", recordStatus.ToString());
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);
return(0);
}
}
/// <summary>
/// Change Status
/// </summary>
/// <param name="status"></param>
/// <param name="activityCode"></param>
/// <returns></returns>
public bool ChangestatusforActivityMaster(string status, string activityCode)
{
string companyCode = _objcurrentInfo.GetCompanyCode();
string DocStatus = string.Empty;
bool changeResult = false;
try
{
DocStatus = status.ToUpper() == "ENABLED" ? "1" : "0"; //1 is enabled, 0 is disabled
BLMaster Master = new BLMaster();
string CompanyCode = _objcurrentInfo.GetCompanyCode();
Master.ChangeStatusForActivityMaster(companyCode, activityCode, DocStatus);
changeResult = true;
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:companyCode", companyCode);
dicContext.Add("Filter:status", status);
dicContext.Add("Filter:activityCode", activityCode);
changeResult = false;
}
return(changeResult);
}
//Bind Region
public JsonResult GetRegionList(string regionTypecode)
{
try
{
BLMaster objMaster = new BLMaster();
ProductPriceMasterModel objDropRegion = new ProductPriceMasterModel();
objDropRegion.Company_Code = _objcurrentInfo.GetCompanyCode();
objDropRegion.Region_Type_Code = regionTypecode;
IEnumerable <ProductPriceMasterModel> lstdropregiontype = objMaster.GetRegion(objDropRegion);
var DropRegionList = (from region in lstdropregiontype.AsEnumerable()
select new ProductPriceMasterModel()
{
Region_Name = region.Region_Name.ToString(),
Region_Code = region.Region_Code.ToString()
}).ToList <ProductPriceMasterModel>();
return(Json(DropRegionList));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);
return(null);
}
}
//Bind UnderUserType
public JsonResult GetUnderUserType()
{
string companyCode = _objcurrentInfo.GetCompanyCode();
try
{
BLMaster Master = new BLMaster();
DataTable dtDivision = null;
List <UserTypeMasterModel> Divisionlst = new List <UserTypeMasterModel>();
DataSet ds = Master.Getdivisions(companyCode);
if (ds != null && ds.Tables != null && ds.Tables.Count > 0)
{
dtDivision = ds.Tables[0];
}
Divisionlst = (from Division in dtDivision.AsEnumerable()
select new UserTypeMasterModel
{
User_Type_Code = Division["User_Type_Code"].ToString(),
User_Type_Name = Division["User_Type_Name"].ToString()
}).ToList <UserTypeMasterModel>();
return(Json(Divisionlst));
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(null);
}
}
/// <summary>
/// Used to get the drop Domain List
/// </summary>
/// <returns></returns>
public JsonResult GetDomain()
{
try
{
BLMaster objMaster = new BLMaster();
ProjectMasterModel objprojectdomain = new ProjectMasterModel();
objprojectdomain.Company_Code = _objcurrentInfo.GetCompanyCode();
IEnumerable <ProjectMasterModel> lstprojectdomain = objMaster.GetDomain(objprojectdomain);
var DivisionList = (from division in lstprojectdomain.AsEnumerable()
select new ProjectMasterModel()
{
Domain_Name = division.Domain_Name,
Domain_Code = division.Domain_Code
}).ToList <ProjectMasterModel>();
return(Json(DivisionList));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);
return(null);
}
}
public string checkWAUser()
{
StringBuilder strContent = new StringBuilder();
int chkCount = 0;
try
{
BLMaster objMaster = new BLMaster();
string companyCode = _objcurrentInfo.GetCompanyCode();
string userCode = _objcurrentInfo.GetUserCode();
string userName = _objcurrentInfo.GetUserName();
chkCount = objMaster.checkWAUser(companyCode, userCode);
if (chkCount == 0)
{
strContent.Append(userName + " Can't make a request,Since you are not a valid Wide Angle user,you are not allowed to make this request");
}
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(null);
}
string result = strContent.ToString();
if (string.IsNullOrEmpty(result))
{
result = "SUCCESS";
}
return(result);
}
//Method is Used to bind the Data with RequestMaste Html Table
public string GetRequestMaster()
{
string companycode = _objcurrentInfo.GetCompanyCode();
try
{
List <RequestMasterModel> lstRequestmastermodel = (List <RequestMasterModel>)GetRequestMasterDetails();
StringBuilder sb = new StringBuilder();
BLMaster objMaster = new BLMaster();
sb.Append("<table WIDTH='70%' id='tblsummary' class='table table-striped'>");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:#428bca;'>");
sb.Append("<td>Edit</td>");
sb.Append("<td>Change Status</td>");
sb.Append("<td>Request Name</td>");
sb.Append("<td>Request Entity</td>");
sb.Append("<td>Request Type</td>");
sb.Append("<td>Credit Limit</td>");
sb.Append("<td>Cycle</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
if (lstRequestmastermodel != null && lstRequestmastermodel.Count > 0)
{
int i = 0;
foreach (var lstRequest in lstRequestmastermodel)
{
i++;
sb.Append("<tr><td><a href='#' id='E" + i + "' onclick='fnEditRequestMaster(this)'>Edit</a></td>");
sb.Append("<td><a href='#' id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>");
sb.Append("<td style='display:none' id='Request_Code" + i + "'>" + lstRequest.Request_Code + "</td>");
sb.Append("<td id='Request_Name" + i + "'>" + lstRequest.Request_Name + "</td>");
sb.Append("<td id='Request_Entity" + i + "'>" + lstRequest.Request_Entity + "</td>");
sb.Append("<td id='Request_Type" + i + "'>" + lstRequest.Request_Type + "</td>");
sb.Append("<td id='Credit_Limit" + i + "'>" + lstRequest.Credit_Limit + "</td>");
sb.Append("<td style='display:none' id='Cycle_Code" + i + "'>" + lstRequest.Cycle_Code + "</td>");
sb.Append("<td id='Cycle_Name" + i + "'>" + lstRequest.Cycle_Name + "</td>");
sb.Append("<td id='Record_Status" + i + "'>" + lstRequest.Record_Status + "</td></tr>");
}
}
else
{
sb.Append("<span>No Records TO Display</span>");
}
sb.Append("</body>");
sb.Append("</table>");
return(sb.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:CompanyCode", companycode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
public JsonResult InsertAdjustment(List <InwardAdj> lstInwardAdj)
{
string response = string.Empty;
BLMaster _objBLMaster = new BLMaster();
response = _objBLMaster.InsertAdjustment(lstInwardAdj);
return(Json(response, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// InsertandUpdate
/// </summary>
/// <param name="regionTypecode"></param>
/// <param name="regionCode"></param>
/// <param name="productCode"></param>
/// <param name="price"></param>
/// <param name="effectiveFrom"></param>
/// <param name="effectiveTo"></param>
/// <param name="Mode"></param>
/// <param name="priceCodeval"></param>
/// <returns></returns>
public int InsertandUpdateProductprice(string regionTypecode, string regionCode, string productCode, string price, string effectiveFrom,
string effectiveTo, string Mode, string priceCodeval)
{
string result1 = string.Empty;
BLMaster Master = new BLMaster();
ProductPriceMasterModel objproductPricemasterModer = new ProductPriceMasterModel();
List <ProductPriceMasterModel> lstproductprice = new List <ProductPriceMasterModel>();
try
{
if (Mode.ToUpper() == "I") // Insert Data
{
objproductPricemasterModer.Company_Code = _objcurrentInfo.GetCompanyCode();
objproductPricemasterModer.Region_Type_Code = regionTypecode;
objproductPricemasterModer.Region_Code = regionCode;
objproductPricemasterModer.Product_Code = productCode;
objproductPricemasterModer.Price_Status = "1";
objproductPricemasterModer.Price = price;
objproductPricemasterModer.Effective_From = effectiveFrom;
objproductPricemasterModer.Effective_To = effectiveTo;
objproductPricemasterModer.Created_By = _objcurrentInfo.GetUserName();
objproductPricemasterModer.Created_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
lstproductprice.Add(objproductPricemasterModer);
int result = Master.InsertforProductPriceMaster(lstproductprice);
return(result);
}
else
{
objproductPricemasterModer.Company_Code = _objcurrentInfo.GetCompanyCode();
objproductPricemasterModer.Region_Type_Code = regionTypecode;
objproductPricemasterModer.Region_Code = regionCode;
objproductPricemasterModer.Product_Code = productCode;
objproductPricemasterModer.Price_Code = priceCodeval;
objproductPricemasterModer.Price = price;
objproductPricemasterModer.Effective_From = effectiveFrom;
objproductPricemasterModer.Effective_To = effectiveTo;
objproductPricemasterModer.Updated_By = _objcurrentInfo.GetUserName();
objproductPricemasterModer.Updated_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
lstproductprice.Add(objproductPricemasterModer);
int result = Master.UpdateforProductpriceMaster(lstproductprice);
return(result);
}
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:regionTypecode", regionTypecode);
dicContext.Add("Filter:regionCode", regionCode);
dicContext.Add("Filter:productCode", productCode);
dicContext.Add("Filter:Mode", Mode);
dicContext.Add("Filter:price", price);
dicContext.Add("Filter:effectiveFrom", effectiveFrom);
dicContext.Add("Filter:effectiveTo", effectiveTo);
dicContext.Add("Filter:priceCodeval", priceCodeval);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(0);
}
}
/// <summary>
/// DownLoad The statusMasterDetails into Excel
/// </summary>
/// <returns></returns>
public void PutStatusMasterIntoExcel()
{
string companycode = _objcurrentInfo.GetCompanyCode();
string error = string.Empty;
try
{
List <StatusMasterModel> lstStatusMaster = (List <StatusMasterModel>)GetStatusMasterDetails();
StringBuilder sb = new StringBuilder();
BLMaster objMaster = new BLMaster();
DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload();
DataControl.Abstraction.IFileProvider objProvider = new DataControl.Impl.FileSystemProvider();
sb.Append("<table WIDTH='40%' id='tblsummary' class='table table-striped'>");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:#428bca;'>");
sb.Append("<td>Status Name</td>");
sb.Append("<td>Display Name</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
if (lstStatusMaster != null && lstStatusMaster.Count > 0)
{
int i = 0;
foreach (var lstStatus in lstStatusMaster)
{
i++;
sb.Append("<td id='Status_Name" + i + "'>" + lstStatus.Status_Name + "</td>");
sb.Append("<td id='Display_Name" + i + "'>" + lstStatus.Display_Name + "</td>");
sb.Append("<td id='Record_Status" + i + "'>" + lstStatus.Record_Status + "</td></tr>");
}
}
else
{
sb.Append("<span>No Records TO Display</span>");
}
sb.Append("</body>");
sb.Append("</table>");
DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider();
DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload();
string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
string userName = _objcurrentInfo.GetUserName();
string subdomainName = System.Web.HttpContext.Current.Request.Url.DnsSafeHost;;
string fileName = "Status Master" + " - " + subdomainName + " - " + userName + ".xls";
string blobUrl = objAzureBlob.AzureBlobUploadText(sb.ToString(), accKey, fileName, "bulkdatasvc");
objFileDownload.DownloadFile(blobUrl, fileName, out error);
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
}
}
/// <summary>
/// Method to bind the data with HtmlCycleMaster Table
/// </summary>
/// <returns></returns>
public string GetCycleMaster()
{
string companyCode = _objcurrentInfo.GetCompanyCode();
string regionCode = _objcurrentInfo.GetRegionCode();
string strRegionCode = string.Empty;
try
{
List <CycleMasterModel> lstCycleMaster = (List <CycleMasterModel>)GetcycleMasterDetails(regionCode);
StringBuilder sb = new StringBuilder();
BLMaster objMaster = new BLMaster();
sb.Append("<table WIDTH='60%' id='tblsummary' class='table table-striped'>");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:#428bca;'>");
sb.Append("<td>Edit</td>");
sb.Append("<td>Cycle Name</td>");
sb.Append("<td>Region Name</td>");
sb.Append("<td>Description</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
if (lstCycleMaster != null && lstCycleMaster.Count > 0)
{
int i = 0;
foreach (var lstcycle in lstCycleMaster)
{
i++;
sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>");
sb.Append("<td style='display:none' id='Cycle_Code" + i + "'>" + lstcycle.Cycle_Code + "</td>");
sb.Append("<td id='Cycle_Name" + i + "'>" + lstcycle.Cycle_Name + "</td>");
sb.Append("<td style='display:none' id='Region_Code" + i + "'>" + lstcycle.Region_Code + "</td>");
sb.Append("<td id='Region_Name" + i + "'>" + lstcycle.Region_Name + "</td>");
sb.Append("<td style='display:none' id='Start_Date" + i + "'>" + lstcycle.Start_Date + "</td>");
sb.Append("<td style='display:none' id='End_Date" + i + "'>" + lstcycle.End_Date + "</td>");
sb.Append("<td id='Long_Description" + i + "'>" + lstcycle.Long_Description + "</td>");
sb.Append("<td id='Record_Status" + i + "'>" + lstcycle.Record_Status + "</td></tr>");
}
}
else
{
sb.Append("<span>No Records TO Display</span>");
}
sb.Append("</body>");
sb.Append("</table>");
return(sb.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:regionCode", regionCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
public string UpdateProfileDetails(MVCModels.HiDoctor_Master.popupEmployeeModel objEmpdata)
{
string companyCode = _objcurrentInfo.GetCompanyCode();
string userCode = _objcurrentInfo.GetUserCode();
BLMaster _objBlMaster = new BLMaster();
return(_objBlMaster.UpdateProfileDetails(companyCode, userCode, objEmpdata.Mail, objEmpdata.Mobile, objEmpdata.Phn, objEmpdata.Add1, objEmpdata.Add2, objEmpdata.Add3, objEmpdata.City, objEmpdata.State, objEmpdata.Pincode, objEmpdata.Bloodgroup, objEmpdata.Employeephoto));
}
/// <summary>
/// Method to bind the data with HtmDoctorcategoryMaster Table
/// </summary>
/// <returns></returns>
public string GetDoctorCatgegory()
{
string companycode = _objcurrentInfo.GetCompanyCode();
try
{
BLMaster _objmaster = new BLMaster();
List <MVCModels.HiDoctor_Master.DoctorModel> lstdoctcategory = (List <MVCModels.HiDoctor_Master.DoctorModel>)GetdoctorcategoryDetails();
//dsc
StringBuilder sb = new StringBuilder();
sb.Append("<table WIDTH='100%' id='tblsummary' class='table table-striped' >");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:#428bca;'>");
sb.Append("<td>Edit</td>");
sb.Append("<td>Change Status</td>");
sb.Append("<td>Doctor Category Name</td>");
sb.Append("<td>Visit Count</td>");
sb.Append("<td>Doctor Count</td>");
sb.Append("<td>Division Name</td>");
sb.Append("<td>Effective From</td>");
sb.Append("<td>Effective To</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
//
if (lstdoctcategory != null && lstdoctcategory.Count > 0)
{
int i = 0;
foreach (var lstdoc in lstdoctcategory)
{
i++;
sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>");
sb.Append("<td class='td-a'><a id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>");
sb.Append("<td style='display:none' id='Category_Code" + i + "'>" + lstdoc.Category_Code + "</td>");
sb.Append("<td id='Category_Name" + i + "'>" + lstdoc.Category_Name + "</td>");
sb.Append("<td id='Visit_Count" + i + "'>" + lstdoc.Visit_Count + "</td>");
sb.Append("<td id='Doctor_Count" + i + "'>" + lstdoc.Doctor_Count + "</td>");
sb.Append("<td style='display:none' id='Division_Code" + i + "'>" + lstdoc.Division_Code + "</td>");
sb.Append("<td id='Division_Name" + i + "'>" + lstdoc.Division_Name + "</td>");
sb.Append("<td id='Effective_From" + i + "'>" + lstdoc.Effective_From + "</td>");
sb.Append("<td id='Effective_To" + i + "'>" + lstdoc.Effective_To + "</td>");
sb.Append("<td id='Status" + i + "'>" + lstdoc.Status + "</td></tr>");
}
}
sb.Append("</tbody>");
sb.Append("</table>");
return(sb.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
public string GetPrivilegeValue(string userCode, string privilegeName)
{
string pri = "";
BLMaster obj = new BLMaster();
string companyCode = _objCurrentInfo.GetCompanyCode();
pri = obj.GetPrivilegeValue(companyCode, userCode, privilegeName);
return(pri);
}
/// <summary>
/// Insert and Update
/// </summary>
/// <param name="featureName"></param>
/// <param name="effectiveFrom"></param>
/// <param name="featureCodeval"></param>
/// <param name="description"></param>
/// <param name="Mode"></param>
/// <returns></returns>
public int InsertandUpdateFeatureMaster(string featureName, string effectiveFrom, string featureCodeval, string description, string Mode)
{
BLMaster Master = new BLMaster();
FeatureMasterModel objfeaturemasterModel = new FeatureMasterModel();
List <FeatureMasterModel> lstfeaturemaster = new List <FeatureMasterModel>();
try
{
if (Mode.ToUpper() == "I") // Insert Data
{
if (string.IsNullOrEmpty(description))
{
description = "";
}
objfeaturemasterModel.Company_Code = _objcurrentInfo.GetCompanyCode();
objfeaturemasterModel.Feature_Name = featureName;
objfeaturemasterModel.Effective_From = effectiveFrom;
objfeaturemasterModel.Description = description;
objfeaturemasterModel.Record_Status = "1";
objfeaturemasterModel.Is_Active = "1";
objfeaturemasterModel.Created_By = _objcurrentInfo.GetUserName();
objfeaturemasterModel.Created_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
lstfeaturemaster.Add(objfeaturemasterModel);
int result = Master.InsertforFeatureMaster(lstfeaturemaster);
return(result);
}
else
{
if (string.IsNullOrEmpty(description))
{
description = "";
}
objfeaturemasterModel.Company_Code = _objcurrentInfo.GetCompanyCode();
objfeaturemasterModel.Feature_Code = featureCodeval;
objfeaturemasterModel.Feature_Name = featureName;
objfeaturemasterModel.Effective_From = effectiveFrom;
objfeaturemasterModel.Description = description;
objfeaturemasterModel.Updated_By = _objcurrentInfo.GetUserName();
objfeaturemasterModel.Updated_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
lstfeaturemaster.Add(objfeaturemasterModel);
int result = Master.UpdateforFeatureMaster(lstfeaturemaster);
return(result);
}
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:featureName", featureName);
dicContext.Add("Filter:effectiveFrom", effectiveFrom);
dicContext.Add("Filter:featureCodeval", featureCodeval);
dicContext.Add("Filter:Mode", Mode);
dicContext.Add("Filter:description", description);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(0);
}
}
public string GetInvalidFiles(string docUploadId)
{
StringBuilder strTbl = new StringBuilder();
_objBlMaster = new BLMaster();
List <MVCModels.InvalidFiles> lstInvalidFiles = new List <InvalidFiles>();
int s = 0;
try
{
lstInvalidFiles = _objBlMaster.GetInvalidFiles(_objcurrentInfo.GetCompanyCode(), docUploadId).ToList();
strTbl.Append("<table WIDTH='100%' id='tblMydoc' class='table table-striped'>");
strTbl.Append("<thead class='active'>");
strTbl.Append("<tr style='background-color:#428bca;'>");
strTbl.Append("<th>S.No</th><th>Invalid File Name</th><th>Reason</th>");
strTbl.Append("</tr>");
strTbl.Append("</thead>");
strTbl.Append("<tbody>");
if (lstInvalidFiles != null && lstInvalidFiles.Count > 0)
{
foreach (var fileName in lstInvalidFiles)
{
s++;
strTbl.Append("<tr>");
//S.No
strTbl.Append("<td>");
strTbl.Append(s);
strTbl.Append("</td>");
//Invalid File Name
strTbl.Append("<td>");
strTbl.Append(fileName.Doc_file_Name);
strTbl.Append("</td>");
//Reason
strTbl.Append("<td>");
strTbl.Append(fileName.ERR_REASON);
strTbl.Append("</td>");
strTbl.Append("</tr>");
}
}
else
{
strTbl.Append("No Details Found.");
}
strTbl.Append("</tbody>");
strTbl.Append("</table>");
return(strTbl.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("docUploadId", docUploadId);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
public JsonResult GetRequestCategoryNames()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
BLMaster _objMaster = new BLMaster();
List <DCRRestrictionModel> lstrequestCategoryNames = new List <DCRRestrictionModel>();
lstrequestCategoryNames = _objMaster.GetRequestCategoryName(_objcurrentInfo.GetCompanyCode()).ToList();
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(Json(objJson.Serialize(lstrequestCategoryNames)));
}
public JsonResult GetUserType()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
BLMaster _objMaster = new BLMaster();
List <DivisionUserProducts> lstUserType = new List <DivisionUserProducts>();
lstUserType = _objMaster.GetUserTypeNamesforProductMapping(_objcurrentInfo.GetCompanyCode()).ToList();
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(Json(objJson.Serialize(lstUserType)));
}
/// <summary>
/// Bind the ExpenseEntityMaster with Html table
/// </summary>
/// <returns></returns>
public string GetExpenseEntityMaster()
{
string companyCode = _objcurrentInfo.GetCompanyCode();
try
{
BLMaster Master = new BLMaster();
DataSet dsExpenseEntityMaster = new DataSet();
dsExpenseEntityMaster = Master.GetExpenseEntityMaster(companyCode);
StringBuilder sb = new StringBuilder();
sb.Append("<table WIDTH='75%' id='tblsummary' class='table table-striped' >");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:grey;'>");
sb.Append("<td>Edit</td>");
sb.Append("<td>Change Status</td>");
sb.Append("<td>Entity Name</td>");
sb.Append("<td>Effective From</td>");
sb.Append("<td>Effective To</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
if (dsExpenseEntityMaster != null && dsExpenseEntityMaster.Tables[0] != null && dsExpenseEntityMaster.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsExpenseEntityMaster.Tables[0].Rows.Count; i++)
{
sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>");
sb.Append("<td class='td-a'><a id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>");
sb.Append("<td style='display:none' id='Expense_Entity_Code" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Expense_Entity_Code"].ToString() + "</td>");
sb.Append("<td id='Expense_Entity_Name" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Expense_Entity_Name"].ToString() + "</td>");
sb.Append("<td id='Effective_From" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Effective_From"].ToString() + "</td>");
sb.Append("<td id='Effective_To" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Effective_To"].ToString() + "</td>");
sb.Append("<td id='Row_Status" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Row_Status"].ToString() + "</td></tr>");
}
}
else
{
sb.Append("<tr><td>No records To Display</td></tr>");
}
sb.Append("</body>");
sb.Append("</table>");
return(sb.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:companyCode", companyCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
public JsonResult GetSFCExtendedDetails(string region_code, DateTime dcr_Date, int distance_Fare_Code)
{
BLMaster objMaster = new BLMaster();
_objCurrentInfo = new CurrentInfo();
string company_Code = _objCurrentInfo.GetCompanyCode();
List <SFCRegionModel> lsSFCRegion = objMaster.GetSFCExtendedDetails(region_code, dcr_Date, distance_Fare_Code, company_Code);
return(Json(lsSFCRegion));
}
public JsonResult GetRegionSFC(string region_code, DateTime dcr_Date)
{
BLMaster objMaster = new BLMaster();
_objCurrentInfo = new CurrentInfo();
string company_Code = _objCurrentInfo.GetCompanyCode();
List <SFCRegionModel> lsSFCRegion = objMaster.GetRegionSFC(region_code, dcr_Date, company_Code);
return(Json(lsSFCRegion));
}
/// <summary>
/// Method is used to bind the data with Html Table
/// </summary>
/// <returns></returns>
public string GetFeatureMaster()
{
string companycode = _objcurrentInfo.GetCompanyCode();
try
{
List <FeatureMasterModel> lstfeaturemaster = (List <FeatureMasterModel>)GetFeatureMasterDetails();
StringBuilder sb = new StringBuilder();
BLMaster objMaster = new BLMaster();
sb.Append("<table WIDTH='60%' id='tblsummary' class='table table-striped'>");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:#428bca;'>");
sb.Append("<td>Select</td>");
sb.Append("<td>Change Status</td>");
sb.Append("<td>Feature Type</td>");
sb.Append("<td>Description</td>");
sb.Append("<td>Effective From</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
if (lstfeaturemaster != null && lstfeaturemaster.Count > 0)
{
int i = 0;
foreach (var lstfeature in lstfeaturemaster)
{
i++;
sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>");
sb.Append("<td class='td-a'><a id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>");
sb.Append("<td style='display:none' id='Feature_Code" + i + "'>" + lstfeature.Feature_Code + "</td>");
sb.Append("<td id='Feature_Name" + i + "'>" + lstfeature.Feature_Name + "</td>");
sb.Append("<td id='Description" + i + "'>" + lstfeature.Description + "</td>");
sb.Append("<td id='Effective_From" + i + "'>" + lstfeature.Effective_From + "</td>");
sb.Append("<td id='Record_Status" + i + "'>" + lstfeature.Record_Status + "</td></tr>");
}
}
else
{
sb.Append("<span>No Records TO Display</span>");
}
sb.Append("</body>");
sb.Append("</table>");
return(sb.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:CompanyCode", companycode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
