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(); } }