public DataSet GetCPDetails(string companyCode, string regionCode)
{
DataSet ds = new DataSet();
try
{
SqlCommand command = new SqlCommand(SP_HDGETCPDETAILS);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@RegionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, regionCode);
_objData.OpenConnection();
ds = _objData.ExecuteDataSet(command);
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
dicObj.Add("regionCode", regionCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
throw ex;
}
finally
{
_objData.CloseConnection();
}
return(ds);
}
public bool InsertHelpDescription(string pageId, string controlId, string helpItemId, string helpDescrip, out string errorMsg)
{
try
{
SPData _objSPData = new SPData();
SqlCommand command = new SqlCommand(SPHDINSERTHELPDESCRP);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@PageId", ParameterDirection.Input, SqlDbType.VarChar, 100, pageId);
_objSPData.AddParamToSqlCommand(command, "@ControlId", ParameterDirection.Input, SqlDbType.VarChar, 100, controlId);
_objSPData.AddParamToSqlCommand(command, "@HelpItemId", ParameterDirection.Input, SqlDbType.VarChar, 100, helpItemId);
_objSPData.AddParamToSqlCommand(command, "@HelpDescrp", ParameterDirection.Input, SqlDbType.VarChar, helpDescrip.Length, helpDescrip);
_objData.OpenConnection_Global();
DataSet dsConnectionString = _objData.ExecuteDataSet(command);
errorMsg = string.Empty;
return(true);
}
catch (Exception ex)
{
errorMsg = ex.Message;
return(false);
}
finally
{
_objData.CloseConnection();
}
}
public JsonResult GetActicitySummary(FormCollection coll)
{
try
{
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
DataSet dsActivity = new DataSet();
string toDate = DateTime.Now.ToShortDateString();
string fromDate = string.Empty;
//fromDate = toDate.Split('-')[0] + "-" + toDate.Split('-')[1] + "-01";
fromDate = DateTime.Now.Month + "/01/" + DateTime.Now.Year;
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsActivity = objData.ExecuteDataSet("exec SP_hdGetActivitySummaryIR '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "','" + fromDate + "','" + toDate + "'");
}
return(Json(objJson.Serialize(dsActivity)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
objData.CloseConnection();
}
}
public JsonResult GetDCRAppliedUsers(FormCollection collection)
{
try
{
DataSet dsCategory = new DataSet();
objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
dsCategory = objData.ExecuteDataSet("exec SP_mhdGetDCRAppliedUsers '" + _objCurrentInfo.GetCompanyCode() + "','" + _objCurrentInfo.GetUserCode() + "','" + collection["DCRActualMonth"].ToString() + "','" + collection["DCRActualYear"].ToString() + "','" + collection["Status"].ToString() + "','" + collection["Selection"].ToString() + "','" + collection["UserName"].ToString() + "'");
}
return(Json(_objJson.Serialize(dsCategory), JsonRequestBehavior.AllowGet));
}
finally
{
objData.CloseConnection();
}
}
//sample product method//
public JsonResult GetAllproduct(FormCollection collection)
{
DataControl.Data ds = new DataControl.Data();
try
{
string UserCode = string.Empty;
DataSet dssub = new DataSet();
ds.OpenConnection(objCurrentInfo.GetCompanyCode());
{
string StrSQL = "EXEC USP_hdGetActivityTypeMapping " + "'" + objCurrentInfo.GetCompanyCode() + "'";
dssub = ds.ExecuteDataSet(StrSQL);
}
DataTable dt = new DataTable();
dt = dssub.Tables[0];
List <Models.SalestypeMapping> lstMOdel = (from c in dt.AsEnumerable()
select new Models.SalestypeMapping
{
ProductName = c["Product_Name"].ToString(),
BrandName = c["Brand_Name"].ToString(),
SpecialityName = c["Speciality_Name"].ToString(),
Productcode = c["Product_code"].ToString(),
}).ToList <Models.SalestypeMapping>();
return(Json(lstMOdel, JsonRequestBehavior.AllowGet));
}
finally
{
ds.CloseConnection();
}
}
public DataSet GetLeaveTypeDetails(string companycode)
{
DataSet ds;
_objSPData = new SPData();
_objData = new Data();
try
{
SqlCommand command = new SqlCommand(SP_HD_GetLeaveDeatils);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@companycode", ParameterDirection.Input, SqlDbType.VarChar, 30, companycode);
_objData.OpenConnection(companycode);
ds = _objData.ExecuteDataSet(command);
return(ds);
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
}
//Get mapping product//
public JsonResult GetAllSelectProduct(FormCollection collection)
{
DataControl.Data ds = new DataControl.Data();
try
{
string salesproductCode = string.Empty;
string Result = string.Empty;
salesproductCode = collection["ProductCodeselect"];
DataSet dssub = new DataSet();
ds.OpenConnection(objCurrentInfo.GetCompanyCode());
{
string StrSQL = "EXEC SP_HdGet_MappingProductSelect " + "'" + objCurrentInfo.GetCompanyCode() + "','" + salesproductCode + "'";
dssub = ds.ExecuteDataSet(StrSQL);
}
DataTable dt = new DataTable();
dt = dssub.Tables[0];
List <Models.SalestypeMapping> lstMOdel = (from c in dt.AsEnumerable()
select new Models.SalestypeMapping
{
Productcode = c["Sales_Product_Code"].ToString(),
SalesMappingcode = c["Mapping_Product_Code"].ToString(),
}).ToList <Models.SalestypeMapping>();
return(Json(lstMOdel, JsonRequestBehavior.AllowGet));
}
finally
{
ds.CloseConnection();
}
}
//get history table////
public JsonResult GetAllstock(FormCollection collection)
{
string UserCode = string.Empty;
UserCode = collection["UserCode"];
string InwardDate = string.Empty;
//InwardDate = collection["InwardDate"];
if (!string.IsNullOrEmpty(collection["InwardDate"].ToString()))
{
InwardDate = collection["InwardDate"].ToString().Split('-')[2].ToString() + "-" + collection["InwardDate"].ToString().Split('-')[1].ToString() + "-" + collection["InwardDate"].ToString().Split('-')[0].ToString();
}
//InwardDate = Convert.ToDateTime(collection["InwardDate"].ToString()).ToString("yyyy-MM-dd");
DataControl.Data ds = new DataControl.Data();
DataSet dssub = new DataSet();
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
string StrSQL = "EXEC SP_hdInwardStockValue " + "'" + _objCurrentInfo.GetCompanyCode() + "','" + UserCode + "','" + InwardDate + "'";
dssub = ds.ExecuteDataSet(StrSQL);
ds.CloseConnection();
}
DataTable dt = new DataTable();
dt = dssub.Tables[0];
List <Models.InwardModel> lstMOdel = (from c in dt.AsEnumerable()
select new Models.InwardModel
{
InwardDate = c["Inward Date"].ToString(),
product = c["Product"].ToString(),
count = c["Count"].ToString(),
}).ToList <Models.InwardModel>();
return(Json(lstMOdel, JsonRequestBehavior.AllowGet));
}
public DataSet GetTpconsolidatedReport(string UserCode, string Month, string Year, string company_Code)
{
_objData = new Data();
DataSet ds = new DataSet();
try
{
SqlCommand cmd = new SqlCommand("HD_SP_TpReport");
cmd.CommandType = CommandType.StoredProcedure;
AddParamToSqlCommand(cmd, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, company_Code);
AddParamToSqlCommand(cmd, "@Month", ParameterDirection.Input, SqlDbType.Int, 8, Month);
AddParamToSqlCommand(cmd, "@year", ParameterDirection.Input, SqlDbType.Int, 8, Year);
AddParamToSqlCommand(cmd, "@user_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, UserCode);
//cmd.Parameters.Add("@Company_Code", company_Code);
//cmd.Parameters.Add("@Month", Month);
//cmd.Parameters.Add("@year", Year);
//cmd.Parameters.Add("@user_Code", UserCode);
_objData.OpenConnection();
ds = _objData.ExecuteDataSet(cmd);
_objData.CloseConnection();
}
catch (Exception ex)
{
throw ex;
}
finally
{
_objData.CloseConnection();
}
return(ds);
}
public DataSet GetInstantReportDetails(string companyCode, string userCode, string regionCode, string dcrActualDate, string dcrCode, string flag)
{
SPData _objSPData = new SPData();
Data _objData = new Data();
try
{
string cmdText = SP_HD_V4_GetUserPerDayReport;
SqlCommand command = new SqlCommand(cmdText);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userCode);
_objSPData.AddParamToSqlCommand(command, "@RegionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, regionCode);
_objSPData.AddParamToSqlCommand(command, "@DCRActualDate", ParameterDirection.Input, SqlDbType.VarChar, 12, dcrActualDate);
_objSPData.AddParamToSqlCommand(command, "@DCRCode", ParameterDirection.Input, SqlDbType.VarChar, 50, dcrCode);
_objSPData.AddParamToSqlCommand(command, "@Flag", ParameterDirection.Input, SqlDbType.VarChar, 1, flag);
DataSet ds = new DataSet();
_objData.OpenConnection(companyCode);
ds = _objData.ExecuteDataSet(command);
return(ds);
}
finally
{
_objData.CloseConnection();
}
}
public DataSet GetDailyCallPlannerDoctorDetails(string companyCode, string userCode, string regionCode, string month, string year, string fromDate, string dcrDate)
{
DataSet ds = new DataSet();
SPData _objSPData = new SPData();
Data _objData = new Data();
try
{
SqlCommand command = new SqlCommand(SP_HD_V4_GetDailyPlanDoctorYTD);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userCode);
_objSPData.AddParamToSqlCommand(command, "@RegionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, regionCode);
_objSPData.AddParamToSqlCommand(command, "@Month", ParameterDirection.Input, SqlDbType.VarChar, 5, month);
_objSPData.AddParamToSqlCommand(command, "@YEAR", ParameterDirection.Input, SqlDbType.VarChar, 5, year);
_objSPData.AddParamToSqlCommand(command, "@FromDate", ParameterDirection.Input, SqlDbType.VarChar, 15, fromDate);
_objSPData.AddParamToSqlCommand(command, "@DCRDate", ParameterDirection.Input, SqlDbType.VarChar, 15, dcrDate);
_objData.OpenConnection(companyCode);
ds = _objData.ExecuteDataSet(command);
return(ds);
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
}
public JsonResult GetTargetHeader(FormCollection collection)
{
try
{
DataSet ds = new DataSet();
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
ds = _objData.ExecuteDataSet("exec SP_hdGetTargetHeader '" + _objCurr.GetCompanyCode() + "','" + collection["RegionCode"].ToString() + "'");
}
return(Json(_objJson.Serialize(ds), JsonRequestBehavior.AllowGet));
}
finally
{
_objData.CloseConnection();
}
}
public DataSet GetOrderDetails(string companyCode, string orderId, string mode)
{
DataSet ds = null;
try
{
_objData.OpenConnection(companyCode);
{
ds = _objData.ExecuteDataSet(SP_mhdGetOrderDetails + " '" + companyCode + "','" + orderId + "','" + mode + "'");
}
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
return(ds);
}
public JsonResult GetExpenseTypeDetails(FormCollection coll)
{
try
{
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
DataSet dsExpenseDetails = new DataSet();
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
dsExpenseDetails = _objData.ExecuteDataSet("exec SP_hdGetExpenseTypeDetails '" + _objCurr.GetCompanyCode() + "'");
}
return(Json(objJson.Serialize(dsExpenseDetails)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_objData.CloseConnection();
}
}
public JsonResult GetNewReportsMenu(FormCollection collection)
{
try
{
_objData.OpenConnection(_objcurrentInfo.GetCompanyCode());
DataSet ds = _objData.ExecuteDataSet("exec SP_hdGetUserMenuScreen '" + _objcurrentInfo.GetCompanyCode() + "', '" + _objcurrentInfo.GetUserTypeCode() + "'");
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
finally
{
_objData.CloseConnection();
}
}
public JsonResult GetNotification(FormCollection collection)
{
try
{
DataSet dsCategory = new DataSet();
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsCategory = objData.ExecuteDataSet("exec SP_mhdGetNotification '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "'");
}
return(Json(_objJson.Serialize(dsCategory), JsonRequestBehavior.AllowGet));
}
finally
{
objData.CloseConnection();
}
}
//get user data table//
public JsonResult GetAllInward(FormCollection collection)
{
string UserCode = string.Empty;
UserCode = collection["UserCode"];
string inwardDate = collection["InwardDate"];
DataControl.Data ds = new DataControl.Data();
DataSet dssub = new DataSet();
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
string StrSQL = "EXEC Sp_HdUserProduct_select " + "'" + _objCurrentInfo.GetCompanyCode() + "','" + UserCode + "','" + inwardDate + "'";
dssub = ds.ExecuteDataSet(StrSQL);
ds.CloseConnection();
}
DataTable dt = new DataTable();
DataTable dtBatch = new DataTable();
dt = dssub.Tables[0];
dtBatch = dssub.Tables[1];
List <Models.InwardModel> lstMOdel = (from c in dt.AsEnumerable()
select new Models.InwardModel
{
ProductTypeName = c["Product_Type_Name"].ToString(),
ProductName = c["Product_Name"].ToString(),
CurrentStock = c["Current_Stock"].ToString(),
ProductCode = c["Product_Code"].ToString(),
Effective_Status = Convert.ToInt32(c["Effective_Status"].ToString()),
}).ToList <Models.InwardModel>();
List <Models.InwardBatch> lstBatch = (from c in dtBatch.AsEnumerable()
select new Models.InwardBatch
{
UPB_ID = Convert.ToInt32(c["UPB_ID"].ToString()),
Product_Code = c["Product_Code"].ToString(),
Batch_Number = c["Batch_Number"].ToString(),
Effective_From = c["Effective_From"].ToString(),
Effective_To = c["Effective_To"].ToString(),
Expiry_Date = c["Expiry_Date"].ToString(),
Effective_Status = Convert.ToInt32(c["Effective_Status"].ToString()),
Batch_Status = Convert.ToInt32(c["Batch_Status"].ToString()),
Current_Stock = Convert.ToInt32(c["Current_Stock"].ToString()),
}).ToList <Models.InwardBatch>();
return(Json(new { Product = lstMOdel, Batch = lstBatch }, JsonRequestBehavior.AllowGet));
}
public void UserAuthendication(string companyCode, string userCode, string sessionID)
{
Data objData = new Data();
DataSet dsCurrentInfo = new DataSet();
try
{
// check authendication.
objData.OpenConnection(companyCode);
{
dsCurrentInfo = objData.ExecuteDataSet("exec SP_hdUserAuthendication '" + companyCode + "','" + userCode + "','" + sessionID + "'");
}
if (dsCurrentInfo.Tables.Count > 0)
{
if (dsCurrentInfo.Tables[0].Rows.Count > 0)
{
System.Web.HttpContext.Current.Session["Comp_Code"] = companyCode;
System.Web.HttpContext.Current.Session["User_Code"] = userCode;
System.Web.HttpContext.Current.Session["User_Name"] = dsCurrentInfo.Tables[0].Rows[0]["User_Name"].ToString();
System.Web.HttpContext.Current.Session["Region_Code"] = dsCurrentInfo.Tables[0].Rows[0]["Region_Code"].ToString();
System.Web.HttpContext.Current.Session["Region_Name"] = dsCurrentInfo.Tables[0].Rows[0]["Region_Name"].ToString();
System.Web.HttpContext.Current.Session["User_Type_Code"] = dsCurrentInfo.Tables[0].Rows[0]["User_Type_Code"].ToString();
System.Web.HttpContext.Current.Session["User_Type_Name"] = dsCurrentInfo.Tables[0].Rows[0]["User_Type_Name"].ToString();
System.Web.HttpContext.Current.Session["Latitude"] = dsCurrentInfo.Tables[0].Rows[0]["Lattitude"].ToString();
System.Web.HttpContext.Current.Session["Longitude"] = dsCurrentInfo.Tables[0].Rows[0]["Longitude"].ToString();
System.Web.HttpContext.Current.Session["Location"] = dsCurrentInfo.Tables[0].Rows[0]["Location"].ToString();
}
else
{
// Redirect to session expired page.
}
}
}
catch
{
throw;
}
finally
{
objData.CloseConnection();
dsCurrentInfo.Dispose();
}
}
/// <summary>
/// Get the selected region details
/// </summary>
public JsonResult GetRegionDetails(FormCollection collection)
{
try
{
DataSet ds = new DataSet();
DataControl.Data _objData = new DataControl.Data();
_objData.OpenConnection(_objcurrentInfo.GetCompanyCode());
{
ds = _objData.ExecuteDataSet("EXEC SP_hdGetSelectedRegion '" + _objcurrentInfo.GetCompanyCode() + "','" + collection["RegionCode"].ToString() + "'");
}
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
finally
{
_objData.CloseConnection();
}
}
/// <summary>
/// Get region master details for tree generation
/// </summary>
public JsonResult GetRegionTreeDetails()
{
try
{
DataSet ds = new DataSet();
DataControl.Data _objData = new DataControl.Data();
_objData.OpenConnection(_objcurrentInfo.GetCompanyCode());
{
ds = _objData.ExecuteDataSet("exec SP_hdGetRegionTreeDetails '" + _objcurrentInfo.GetCompanyCode() + "'");
}
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
finally
{
_objData.CloseConnection();
}
}
public JsonResult GetProductGroups()
{
DataControl.Data ds = new DataControl.Data();
try
{
DataSet dsGroup = new DataSet();
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "EXEC sp_sdGetProductGroup '" + objCurInfo.GetCompanyCode() + "'";
dsGroup = ds.ExecuteDataSet(strSQL);
}
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(dsGroup), JsonRequestBehavior.AllowGet));
}
finally
{
ds.CloseConnection();
}
}
public JsonResult GetAllCompetitoractive(FormCollection collection)
{
DataControl.Data ds = new DataControl.Data();
try
{
DataSet dsTrans = new DataSet();
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "EXEC sp_sd_GetAllCompactive '" + objCurInfo.GetCompanyCode() + "'";
dsTrans = ds.ExecuteDataSet(strSQL);
}
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(dsTrans), JsonRequestBehavior.AllowGet));
}
finally
{
ds.CloseConnection();
}
}
public JsonResult GetProductBatches(string ProductCode)
{
DataControl.Data ds = new DataControl.Data();
try
{
DataSet dsTrans = new DataSet();
ds.OpenConnection(objCurInfo.GetCompanyCode());
{
string strSQL = "EXEC SP_HD_GET_ProductBatches '" + ProductCode + "'";
dsTrans = ds.ExecuteDataSet(strSQL);
}
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(dsTrans), JsonRequestBehavior.AllowGet));
}
finally
{
ds.CloseConnection();
}
}
//get product details///
public JsonResult GetAllInwardHistory(FormCollection collection)
{
string UserCode = string.Empty;
string ProductCode = string.Empty;
UserCode = collection["UserCode"];
ProductCode = collection["ProductCode"];
DataControl.Data ds = new DataControl.Data();
DataSet dssub = new DataSet();
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
string StrSQL = "EXEC Sp_HdInwardHistory_Details " + "'" + _objCurrentInfo.GetCompanyCode() + "','" + UserCode + "','" + ProductCode + "'";
dssub = ds.ExecuteDataSet(StrSQL);
ds.CloseConnection();
}
DataTable dt = new DataTable();
DataTable dtBatch = new DataTable();
dt = dssub.Tables[0];
dtBatch = dssub.Tables[1];
List <Models.InwardModel> lstMOdel = (from c in dt.AsEnumerable()
select new Models.InwardModel
{
Username = c["User Name"].ToString(),
ProductName = c["Product Name"].ToString(),
InwardDate = c["Inward Date"].ToString(),
InwardQuantity = c["Inward Quantity"].ToString(),
ThenStock = c["Then Stock"].ToString(),
}).ToList <Models.InwardModel>();
List <Models.InwardBatch> lstBatch = (from c in dtBatch.AsEnumerable()
select new Models.InwardBatch
{
Inward_Date = c["Inward Date"].ToString(),
Batch_Number = c["Batch_Number"].ToString(),
Inward_Stock = Convert.ToInt32(c["Inward Quantity"].ToString()),
Current_Stock = Convert.ToInt32(c["Then Stock"].ToString()),
}).ToList <Models.InwardBatch>();
return(Json(new { Product = lstMOdel, Batch = lstBatch }, JsonRequestBehavior.AllowGet));
}
public DataSet GetExpenseAnalysisReportNG(string companyCode, string userCode, string startDate, string endDate)
{
try
{
SqlCommand command = new SqlCommand(SP_HDGETEXPENSEANALYSISREPORT_NG);
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 400;
objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.NVarChar, 30, companyCode);
objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.NVarChar, 30, userCode);
objSPData.AddParamToSqlCommand(command, "@StartDate", ParameterDirection.Input, SqlDbType.NVarChar, 30, startDate);
objSPData.AddParamToSqlCommand(command, "@EndDate", ParameterDirection.Input, SqlDbType.NVarChar, 30, endDate);
_objData.OpenConnection();
DataSet ds = _objData.ExecuteDataSet(command);
return(ds);
}
finally
{
_objData.CloseConnection();
}
}
public DataSet GetDoctorCoverageCount(string companyCode, string userCodes, int startMonth, int endMonth, int startYear, int endYear)
{
try
{
Data objData = new Data();
SqlCommand command = new SqlCommand(SPEDGETDOCTORCOVERAGECOUNT);
command.CommandType = CommandType.StoredProcedure;
AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
AddParamToSqlCommand(command, "@UserCodes", ParameterDirection.Input, SqlDbType.VarChar, userCodes.Length, userCodes);
AddParamToSqlCommand(command, "@StartMonth", ParameterDirection.Input, SqlDbType.VarChar, 30, startMonth);
AddParamToSqlCommand(command, "@EndMonth", ParameterDirection.Input, SqlDbType.VarChar, 30, endMonth);
AddParamToSqlCommand(command, "@StartYear", ParameterDirection.Input, SqlDbType.VarChar, 30, startYear);
AddParamToSqlCommand(command, "@EndYear", ParameterDirection.Input, SqlDbType.VarChar, 30, endYear);
DataSet dsRpt = objData.ExecuteDataSet(command);
return(dsRpt);
}
finally
{
_objData.CloseConnection();
}
}
public DataSet GetDepotsforPrimarySales(string company_Code)
{
DataSet ds = null;
_objData = new Data();
try
{
_objData.OpenConnection(company_Code);
{
ds = _objData.ExecuteDataSet("" + EXEC + " " + SP_HDGETDEPOTSFORPRIMARYSALES + " '" + company_Code + "'");
}
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
return(ds);
}
public JsonResult GetDailyCallPlanner(FormCollection coll)
{
try
{
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
DataSet dsDailyPlan = new DataSet();
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsDailyPlan = objData.ExecuteDataSet("exec SP_hdGetDailyPlanHeader '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "','" + coll["dcrDate"].ToString() + "'");
}
return(Json(objJson.Serialize(dsDailyPlan)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
objData.CloseConnection();
}
}
public bool SiteMaintenance(string subdomainName)
{
try
{
bool isTrue = true;
if (System.Web.HttpContext.Current.Session["Comp_Code"] == null)
{
isTrue = _objCurrentInfo.SetCompanyCode();
}
if (isTrue)
{
SqlCommand command = new SqlCommand(SPHDMAINTENANCESITE);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@SubDomainName", ParameterDirection.Input, SqlDbType.VarChar, 30, subdomainName);
_objData.OpenConnection_Global();
DataSet ds = _objData.ExecuteDataSet(command);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
finally
{
_objData.CloseConnection();
}
}
/// <summary>
/// Get dependening data for region master insert or upadte
/// </summary>
public JsonResult GetRegionMasterDetails()
{
try
{
DataSet ds = new DataSet();
DataControl.Data _objData = new DataControl.Data();
_objData.OpenConnection(_objcurrentInfo.GetCompanyCode());
{
string strQry = "exec SP_hd_Region_Type_Select '" + _objcurrentInfo.GetCompanyCode() + "';";
strQry += "exec SP_hdGetChildRegionsForRegionMaster '" + _objcurrentInfo.GetCompanyCode() + "'" + "," + "'" + _objcurrentInfo.GetRegionCode() + "';";
strQry += "exec SP_hdGetRegionClassificationMasterData '" + _objcurrentInfo.GetCompanyCode() + "';";
strQry += "exec SP_hdGetExpenseGroup '" + _objcurrentInfo.GetCompanyCode() + "'";
strQry += "exec SP_HD_CheckAssignRegionName'" + _objcurrentInfo.GetCompanyCode() + "'";
ds = _objData.ExecuteDataSet(strQry);
}
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
finally
{
_objData.CloseConnection();
}
}
