/// <summary>
/// get doctors by the filters
/// </summary>
/// <param name="state"></param>
/// <param name="city"></param>
/// <param name="speciality"></param>
/// <param name="NeLatitudeValue"></param>
/// <param name="NeLongitudeValue"></param>
/// <param name="SwLatitudeValue"></param>
/// <param name="SwLongitudeValue"></param>
/// <returns></returns>
public IEnumerable <MVCModels.CCMModel> GetCCMDoctorsByFilters(string country, string state, string city, string speciality, string NeLatitudeValue,
string NeLongitudeValue, string SwLatitudeValue, string SwLongitudeValue, string ccmSearchKey)
{
objCCM = new DAL_CCM();
return(objCCM.GetCCMDoctorsByFilters(country, state, city, speciality, NeLatitudeValue, NeLongitudeValue,
SwLatitudeValue, SwLongitudeValue, ccmSearchKey));
}
/// <summary>
/// Start Soundex
/// </summary>
/// <param name="companyCode"></param>
/// <returns>returns the list of speciality</returns>
public bool CCMProcessSoundex(string subDomain, string processId)
{
try
{
objCCM = new DAL_CCM();
Task task = Task.Factory.StartNew(() => objCCM.CCMProcessSoundex(subDomain, processId));
return(true);
}
catch
{
throw;
}
}
/// <summary>
/// delete the customers from the ccm table
/// </summary>
/// <param name="lstCCMDoctors"></param>
/// <param name="lstCMDoctors"></param>
/// <returns>retuns the no of rows affected</returns>
public int UpdateCCMDoctorIsSimilarStatus(List <MVCModels.CCMModel> lstCCMDoctors)
{
objCCM = new DAL_CCM();
return(objCCM.UpdateCCMDoctorIsSimilarStatus(lstCCMDoctors));
}
/// <summary>
/// insert or update the ccm details
/// </summary>
/// <param name="companyCode"></param>
/// <param name="lstCCM"></param>
/// <param name="mode"></param>
/// <returns>returns the no of rows affected</returns>
public int InsertCCM(string companyCode, List <MVCModels.CCMModel> lstCCM, string mode)
{
objCCM = new DAL_CCM();
return(objCCM.InsertCCM(companyCode, lstCCM, mode));
}
public int UpdateProcessLog(string companyCode, string processId, string userCode, string mode)
{
objCCM = new DAL_CCM();
return(objCCM.UpdateProcessLog(companyCode, processId, userCode, mode));
}
public bool CheckMobileNumberExists(string mobile, int Customer_ID, string Mode)
{
objCCM = new DAL_CCM();
return(objCCM.CheckMobileNumberExists(mobile, Customer_ID, Mode));
}
public IEnumerable <MVCModels.CCMModel> GetCCMDocDetailsforValidation()
{
objCCM = new DAL_CCM();
return(objCCM.GetCCMDocDetailsforValidation());
}
/// <summary>
/// Get LocalArea for Soundex
/// </summary>
/// <param name="companyCode"></param>
/// <returns>returns the list of speciality</returns>
public IEnumerable <MVCModels.CCMModel> GetCCMLocalArea()
{
objCCM = new DAL_CCM();
return(objCCM.GetCCMLocalArea());
}
/// <summary>
/// get child regions by division
/// </summary>
/// <param name="companyCode"></param>
/// <param name="regionCode"></param>
/// <param name="divisionCode"></param>
/// <returns></returns>
public IEnumerable <MVCModels.RegionModel> GetChildRegionsByDivision(string companyCode, string regionCode, string divisionCode)
{
objCCM = new DAL_CCM();
return(objCCM.GetChildRegionsByDivision(companyCode, regionCode, divisionCode));
}
/// <summary>
/// get doctor category by division
/// </summary>
/// <param name="companyCode"></param>
/// <param name="divisionCode"></param>
/// <returns></returns>
public IEnumerable <MVCModels.DoctorCategoryModel> GetDoctorCategoryByDivision(string companyCode, string divisionCode)
{
objCCM = new DAL_CCM();
return(objCCM.GetDoctorCategoryByDivision(companyCode, divisionCode));
}
public IEnumerable <MVCModels.CCMModel> GetMappedDoctors(string companyCode, string regionCode)
{
objCCM = new DAL_CCM();
return(objCCM.GetMappedDoctors(companyCode, regionCode));
}
public int MapCCMToCM(string companyCode, List <MVCModels.CCMModel> lstCCM, string guid, List <MVCModels.CCMModel> lstNewDoctors)
{
objCCM = new DAL_CCM();
return(objCCM.MapCCMToCM(companyCode, lstCCM, guid, lstNewDoctors));
}
/// <summary>
/// Get child regions
/// </summary>
/// <param name="regionCode"></param>
/// <returns></returns>
public IEnumerable <MVCModels.RegionModel> GetRegions(string regionCode)
{
objCCM = new DAL_CCM();
return(objCCM.GetRegions(regionCode));
}
/// <summary>
/// Get divisions
/// </summary>
/// <returns></returns>
public IEnumerable <MVCModels.DivisionModel> GetDivisions()
{
objCCM = new DAL_CCM();
return(objCCM.GetDivisions());
}
public long GetSeqNumber(string objName)
{
objCCM = new DAL_CCM();
return(objCCM.GetSeqNumber(objName));
}
public string GetRegionMaxDoctorCount(string companyCode, string regionCode)
{
objCCM = new DAL_CCM();
return(objCCM.GetRegionMaxDoctorCount(companyCode, regionCode));
}
public string InsertCMFromStagingToMaster(string companyCode, string guid, string uploadedBy, string categoryCode, string regionCode, string regionName)
{
objCCM = new DAL_CCM();
return(objCCM.InsertCMFromStagingToMaster(companyCode, guid, uploadedBy, categoryCode, regionCode, regionName));
}
public IEnumerable <MVCModels.CCMModel> GetSimilarDoctors(string searchKey)
{
objCCM = new DAL_CCM();
return(objCCM.GetSimilarDoctors(searchKey));
}
public int UpdateMDLNumber(string companyCode, List <MVCModels.CCMModel> lstCCM)
{
objCCM = new DAL_CCM();
return(objCCM.UpdateMDLNumber(companyCode, lstCCM));
}
public IEnumerable <MVCModels.CCMModel> GetSimilarDoctorsByLocalArea(string searchKey, string localArea)
{
objCCM = new DAL_CCM();
return(objCCM.GetSimilarDoctorsByLocalArea(searchKey, localArea));
}
/// <summary>
/// Get doctor category
/// </summary>
/// <param name="companyCode"></param>
/// <param name="userCode"></param>
/// <returns>returns the list of category</returns>
public IEnumerable <MVCModels.DoctorCategoryModel> GetDoctorCategory(string companyCode)
{
objCCM = new DAL_CCM();
return(objCCM.GetDoctorCategory(companyCode));
}
public bool CheckRegistrationNumberExists(string regNo, int Customer_ID, string Mode)
{
objCCM = new DAL_CCM();
return(objCCM.CheckRegistrationNumberExists(regNo, Customer_ID, Mode));
}
public string InsertCCMBulkUpload(string subDomain, string companyCode, string guid, System.Web.HttpPostedFileBase postedFile, string uploadedBy)
{
objCCM = new DAL_CCM();
string result = "";
try
{
DataTable dt = ConvertCCMExcelToDataTable(postedFile);
if (dt == null)
{
result = "ERROR:NO DATA found in the uploaded excel file";
}
else if (dt.Rows.Count == 0)
{
result = "ERROR:NO DATA found in the uploaded excel file";
}
else
{
StringBuilder errorResult = new StringBuilder();
dt.Columns.Add("BP_ID", typeof(String));
dt.Columns.Add("Status", typeof(String));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["BP_ID"] = guid.ToString();
dt.Rows[i]["Status"] = "PROCESSING";
}
ArrayList arHeader = new ArrayList();
arHeader.Add("ROW_NO");
arHeader.Add("CUSTOMER_NAME");
arHeader.Add("SUR_NAME");
arHeader.Add("SPECIALITY_NAME");
arHeader.Add("GENDER");
arHeader.Add("QUALIFICATION");
arHeader.Add("ADDRESS1");
arHeader.Add("ADDRESS2");
arHeader.Add("LOCAL_AREA");
arHeader.Add("PIN_CODE");
arHeader.Add("CITY");
arHeader.Add("STATE");
arHeader.Add("COUNTRY");
arHeader.Add("PHONE");
arHeader.Add("MOBILE");
arHeader.Add("FAX");
arHeader.Add("EMAIL");
arHeader.Add("HOSPITAL_NAME");
arHeader.Add("HOSPITAL_CLASSIFICATION");
arHeader.Add("DOB");
arHeader.Add("ANNIVERSARY_DATE");
arHeader.Add("REGISTRATION_NO");
if ((dt.Columns.Count - 2) == arHeader.Count)
{
for (int j = 0; j < dt.Columns.Count - 2; j++)
{
if (!arHeader.Contains(dt.Columns[j].ToString().ToUpper()))
{
errorResult.Append("ERROR: INVALID COLUMN NAME - " + dt.Columns[j].ToString());
}
}
if (string.IsNullOrEmpty(errorResult.ToString()))
{
result = objCCM.CCMExcelBulkCopy(companyCode, dt);
if (result == "SUCCESS")
{
result = objCCM.InsertCCMStagingToMaster(subDomain, guid, _CCMExcelTemplateFileName, uploadedBy, "CCM_UPLOAD");
}
else
{
result = "ERROR:Instructions are not followed.CCM Bulk insert failed." + result;
}
}
else
{
result = errorResult.ToString();
}
}
else
{
result = "ERROR:Instructions are not followed.Some columns are missing or extra columns are added in the excel sheet";
}
}
}
catch (Exception ex)
{
result = "ERROR:Instructions not followed." + ex.Message;
}
return(result);
}
public IEnumerable <MVCModels.CCMSoundexProcessHistory> GetSoundexProcessHistory()
{
objCCM = new DAL_CCM();
return(objCCM.GetSoundexProcessHistory());
}
/// <summary>
/// Get speciality
/// </summary>
/// <param name="companyCode"></param>
/// <returns>returns the list of speciality</returns>
public IEnumerable <MVCModels.SpecialityModel> GetSpeciality(string companyCode)
{
objCCM = new DAL_CCM();
return(objCCM.GetSpeciality(companyCode));
}
/// <summary>
/// Get CCM details
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="isAllRecords"></param>
/// <param name="searchKey"></param>
/// <param name="totalPageCount"></param>
/// <returns>returns the list of CCM details</returns>
public IEnumerable <MVCModels.CCMModel> GetCCMDetails(int pageNumber, int pageSize, bool isAllRecords, string searchKey, ref int totalPageCount)
{
objCCM = new DAL_CCM();
return(objCCM.GetCCMDetails(pageNumber, pageSize, isAllRecords, searchKey, ref totalPageCount));
}
/// <summary>
/// get doctors from ccm by address and speciality
/// </summary>
/// <param name="state"></param>
/// <param name="city"></param>
/// <param name="speciality"></param>
/// <returns></returns>
public IEnumerable <MVCModels.CCMModel> GetCCMDoctorsByAddressandSpeciality(string country, string state, string city, string speciality)
{
objCCM = new DAL_CCM();
return(objCCM.GetCCMDoctorsByAddressandSpeciality(country, state, city, speciality));
}
