public ActionResult User_ChangePassword(string OldPssword, string NewPassword) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(View("~/Views/MasterPages/UserPasswordChange.cshtml")); } }
public ActionResult GetList_TaxCountryMap() { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(View("~/Views/MasterPages/TaxCountryMapList.cshtml", iGstSvc.GetList_TaxCountryMap(0, "", ""))); } }
public ActionResult GetList_Role() { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(View("~/Views/MasterPages/RoleList.cshtml", iGstSvc.GetList_Role("", "", "", false))); } }
public ActionResult GetDetails_Role(string RoleID) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(PartialView("~/Views/MasterPages/RoleDetails.cshtml", iGstSvc.GetDetails_Role(RoleID, "", "", false))); } }
public ActionResult GetDetails_TaxExpenseCountryCategoryMap(string TaxDefinationID, string CountryId, string CategoryId) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(PartialView("~/Views/MasterPages/TaxExpenseCountryCategoryMapDetails.cshtml", iGstSvc.GetDetails_TaxExpenseCountryCategoryMap(0, TaxDefinationID, CountryId, CategoryId))); } }
public ActionResult GetDetails_Product(string ProductID) { if (Session["Language"] == null) { Session["Language"] = 1; } string OrganizationCode = ""; if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null) { OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim(); } ProductInfo obj = iGstSvc.GetDetails_Product(ProductID, "", "", OrganizationCode, "", true, Session["Language"].ToString()); int CountryId = 0; int.TryParse(((UserInfo)Session["UserDetails"]).Country, out CountryId); ViewBag.Categories = CommonMethods.ListCategory(obj.CategoryId, CountryId.ToString()); ViewBag.Countries = CommonMethods.ListCountry(obj.CountryId); using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(PartialView("~/Views/MasterPages/ProductDetails.cshtml", obj)); } }
public ActionResult GetDetails_TaxCountryMap(string TaxDefinationID, string CountryId) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { TaxCountryMapInfo obj = iGstSvc.GetDetails_TaxCountryMap(0, TaxDefinationID, CountryId); ViewBag.Taxes = CommonMethods.ListTaxes(obj.TaxDefinationID); ViewBag.Countries = CommonMethods.ListCountry(obj.CountryId); return(PartialView("~/Views/MasterPages/TaxCountryMapDetails.cshtml", obj)); } }
public ActionResult Get_GstCategory(string CategoryId, string ShipStateId, string OrganizationCode) { if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null) { OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim(); } using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(Json(iGstSvc.Get_GstCategory(CategoryId, ShipStateId, OrganizationCode), JsonRequestBehavior.AllowGet)); } }
public ActionResult GetDashboard_Organization(string FromDate, string ToDate) { if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(View("~/Views/MasterPages/Index.cshtml", new Auth_Svc.UserAuthenticationServiceClient().GetDashboard_Organization(((UserInfo)Session["UserDetails"]).OrganizationCode, FromDate, ToDate, ""))); } } else { return(View("~/Views/MasterPages/Index.cshtml")); } }
public ActionResult GetList_OrganizationAccountant() { string OrganizationCode = ""; if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null) { OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim(); } using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(View("~/Views/MasterPages/OrganizationAccountanList.cshtml", new Auth_Svc.UserAuthenticationServiceClient().GetList_OrganizationAccountant("", OrganizationCode, "", false))); } }
public ActionResult GetDetails_TaxMaster(string TaxDefinationID) { string OrganizationCode = ""; if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null) { OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim(); } using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { return(PartialView("~/Views/MasterPages/TaxMasterDetails.cshtml", iGstSvc.GetDetails_TaxMaster(0, TaxDefinationID))); } }
public ActionResult GetList_ProductOrganizationImage(string ImageId, string OrganizationproductId, string ProductID, string IsActive, string IsMain) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { List <ProductOrganiztionImageInfo> list = new Product_Svc.ProductServiceClient().GetList_ProductOrganizationImage(ImageId, OrganizationproductId, "", "", IsMain); if (list != null && list.Count > 0 && list[0].ImageId > 0) { return(Json(list, JsonRequestBehavior.AllowGet)); } else { return(Json("NO", JsonRequestBehavior.AllowGet)); } } }
public ActionResult Save_TaxMaster(string isOnlyDelete, string TaxDefinationID, string TaxName) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { TaxMasterInfo objBank = new TaxMasterInfo(); objBank.TaxDefinationID = TaxDefinationID; objBank.TaxName = TaxName; if (iGstSvc.Save_TaxMaster(isOnlyDelete.Trim().ToUpper() == "Y", objBank, ((UserInfo)Session["UserDetails"]), out ErrorMessage)) { return(Json("Ok", JsonRequestBehavior.AllowGet)); } } return(Json(ErrorMessage, JsonRequestBehavior.AllowGet)); }
public static string ListTaxes(string SelectedItem) { List <TaxMasterInfo> Suppliers = null; System.Text.StringBuilder sbSupplierList = new System.Text.StringBuilder(); try { if (System.Web.HttpContext.Current.Application["Taxmasterlist"] == null) { Suppliers = new iGst_Svc.GSTServiceClient().GetList_TaxMaster(0, ""); System.Web.HttpContext.Current.Application["Taxmasterlist"] = Suppliers; } else { Suppliers = (List <TaxMasterInfo>)System.Web.HttpContext.Current.Application["Taxmasterlist"]; } } catch (Exception ex) { ErrorLog.LogErrors_Comments(ex.Message + ex.InnerException + ex.StackTrace, "Controler", "Organization ist", ""); Suppliers = new List <TaxMasterInfo>(); } sbSupplierList.AppendLine("<option value=\"\">Select one</option>"); if (Suppliers != null && Suppliers.Count > 0) { foreach (TaxMasterInfo country in Suppliers) { if (!string.IsNullOrEmpty(SelectedItem) && country.TaxDefinationID.Trim() == SelectedItem.Trim()) { sbSupplierList.AppendLine("<option value=\"" + country.TaxDefinationID + "\" selected=\"selected\">" + country.TaxName + "</option>"); } else { sbSupplierList.AppendLine("<option value=\"" + country.TaxDefinationID + "\">" + country.TaxName + "</option>"); } } } return(sbSupplierList.ToString()); }
public ActionResult Save_TaxExpenseCountryCategoryMap(string isOnlyDelete, string TaxDefinationID, string CountryId, string CategoryId, string ApplicableType, string Percentage) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { TaxCountryCategoryMapInfo objBank = new TaxCountryCategoryMapInfo(); objBank.TaxDefinationID = TaxDefinationID; objBank.CountryId = CountryId; objBank.CategoryId = CategoryId; objBank.ApplicableType = ApplicableType; objBank.Percentage = Percentage; if (iGstSvc.Save_TaxExpenseCountryCategoryMap(isOnlyDelete.Trim().ToUpper() == "Y", objBank, ((UserInfo)Session["UserDetails"]), out ErrorMessage)) { return(Json("Ok", JsonRequestBehavior.AllowGet)); } } return(Json(ErrorMessage, JsonRequestBehavior.AllowGet)); }
public ActionResult GetList_ExpenseOrganization() { if (Session["Language"] == null) { Session["Language"] = 0; } string OrganizationCode = ""; if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null) { OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim(); } using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { ViewBag.Organizations = CommonMethods.ListOrganizations(""); return(View("~/Views/MasterPages/ExpenseOrganizationList.cshtml", new Expense_Svc.ExpenseServiceClient().GetList_ExpenseOrganization("", "", "", OrganizationCode, "", true, Session["Language"].ToString()))); } }
public ActionResult GetDetails_ProductOrganizationAddEdit(string OrganizationproductId, string org) { if (Session["Language"] == null) { Session["Language"] = 0; } if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null) { org = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim(); } using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { // Modified on [30th August 2019] by [Partha] cause [Adding isExpense parameter] var list = new Product_Svc.ProductServiceClient().GetList_ProductOrganization(OrganizationproductId, "", "", org, "", true, Session["Language"].ToString()); // END: Modified on[30th August 2019] by[Partha] if (string.IsNullOrEmpty(org) && (list != null && list[0] != null) && list[0].OrganizationCode != null) { org = list[0].OrganizationCode; } ViewBag.Organizations = CommonMethods.ListOrganizations(org); ViewBag.Customers = CommonMethods.ListSupplier(org, list[0].SupplierId.ToString()); ViewBag.PreferedSuppliers = CommonMethods.ListSupplier(org, list[0].SupplierId.ToString()); ViewBag.IncomeAccounts = CommonMethods.ListBanks(org, (list != null && list[0] != null) && list[0].IncomeAccount != null ? list[0].IncomeAccount : ""); ViewBag.Categories = CommonMethods.ListCategory((list != null && list[0] != null) && list[0].CategoryId != null ? list[0].CategoryId : "", "0"); ViewBag.ServiceUnits = CommonMethods.ListServiceUnit(list[0].Unit.ToString()); ViewBag.ServiceTypes = CommonMethods.ListServiceType(list[0].ServiceType.ToString()); ViewBag.ServiceClasses = CommonMethods.ListServiceClass(list[0].Class.ToString()); return(PartialView("~/Views/MasterPages/ProductOrganizationAddEdit.cshtml", list[0])); } }
public ActionResult UploadImageOpen(string type, string ParentId) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { //List<ProductOrganiztionImageInfo> list = iGstSvc.GetList_ProductOrganizationImage("", OrganizationProductId, "", "", ""); ViewBag.type = type; ViewBag.ParentId = ParentId; //if (list != null && list.Count > 0 && list[0].ImageId > 0) //{ return(PartialView("~/Views/MasterPages/UploadImage.cshtml")); //} //else //{ // list = new List<ProductOrganiztionImageInfo>(); // ProductOrganiztionImageInfo obj = new ProductOrganiztionImageInfo(); // obj.FileData = new byte[] { }; // obj.FileName = ""; // obj.FileType = ""; // list.Add(obj); // return PartialView("~/Views/MasterPages/UploadImage.cshtml", list); //} } }
public ActionResult UploadFile(string type, bool Overwrite) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { bool bReturn = false; var result = new { Success = "False", Message = "Error Message" }; string OrganizationCode = "1"; if (((UserInfo)Session["UserDetails"]).UserType == "R") { OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode; } try { for (int i = 0; i < Request.Files.Count; i++) { System.Data.DataSet ds = GetDataSet_Excel(Request.Files[0], out ErrorMessage); if (ErrorMessage.Trim().Length > 0) { result = new { Success = "False", Message = ErrorMessage }; return(Json(result, JsonRequestBehavior.AllowGet)); } bool flag = false; if (type == "C") { new Bill_Svc.BillServiceClient().Upload_Customer("C", Overwrite, ds, OrganizationCode, ((UserInfo)Session["UserDetails"]).UserCode, out bReturn, out ErrorMessage); if (ErrorMessage.Trim().Length == 0) { flag = true; } } else if (type == "S") { new Bill_Svc.BillServiceClient().Upload_Customer("S", Overwrite, ds, OrganizationCode, ((UserInfo)Session["UserDetails"]).UserCode, out bReturn, out ErrorMessage); if (ErrorMessage.Trim().Length == 0) { flag = true; } } else if (type == "CA") { flag = new Master_Svc.MasterServiceClient().Upload_Category(Overwrite, ds, ((UserInfo)Session["UserDetails"]).UserCode, out bReturn, out ErrorMessage); } else if (type == "P") { flag = new Product_Svc.ProductServiceClient().Upload_Product(Overwrite, ds, ((UserInfo)Session["UserDetails"]), out bReturn, out ErrorMessage); } else if (type == "BT") { flag = new Master_Svc.MasterServiceClient().Upload_BankTransaction(Overwrite, false, ds, "", OrganizationCode, ((UserInfo)Session["UserDetails"]), out bReturn, out ErrorMessage); } if (ErrorMessage.Trim().Length > 0) { result = new { Success = "False", Message = ErrorMessage }; return(Json(result, JsonRequestBehavior.AllowGet)); } else if (!flag) { result = new { Success = "False", Message = "No upload activity has been processed." }; return(Json(result, JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { result = new { Success = "False", Message = "Error in Uploading file. Please cocntact with the authority" + ex.Message }; return(Json(result, JsonRequestBehavior.AllowGet)); } result = new { Success = "True", Message = "Data uploaded" }; return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult Save_Role(string isDelete, string isActive, string isOnlyForModerateUsers, string RoleID, string RoleName, string chk_Customer_View, string chk_Customer_Add, string chk_Customer_Edit, string chk_Customer_Delete, string chk_Customer_Audit, string chk_Product_View, string chk_Product_Add, string chk_Product_Edit, string chk_Product_Delete, string chk_Product_Audit, string chk_Organization_View, string chk_Organization_Add, string chk_Organization_Edit, string chk_Organization_Delete, string chk_Organization_Audit, string chk_Branch_View, string chk_Branch_Add, string chk_Branch_Edit, string chk_Branch_Delete, string chk_Branch_Audit, string chk_Category_View, string chk_Category_Add, string chk_Category_Edit, string chk_Category_Delete, string chk_Category_Audit, string chk_Bill_View, string chk_Bill_Add, string chk_Bill_Edit, string chk_Bill_Delete, string chk_Bill_Audit, string chk_Language_View, string chk_Language_Add, string chk_Language_Edit, string chk_Language_Delete, string chk_Language_Audit, string chk_DefineLanguage_View, string chk_DefineLanguage_Add, string chk_DefineLanguage_Edit, string chk_DefineLanguage_Delete, string chk_DefineLanguage_Audit, string chk_StaticValue_View, string chk_StaticValue_Add, string chk_StaticValue_Edit, string chk_StaticValue_Delete, string chk_StaticValue_Audit, string chk_Terms_View, string chk_Terms_Add, string chk_Terms_Edit, string chk_Terms_Delete, string chk_Terms_Audit, string chk_UserRegistered_View, string chk_UserRegistered_Add, string chk_UserRegistered_Edit, string chk_UserRegistered_Delete, string chk_UserRegistered_Audit, string chk_UserModerate_View, string chk_UserModerate_Add, string chk_UserModerate_Edit, string chk_UserModerate_Delete, string chk_UserModerate_Audit, string chk_Role_View, string chk_Role_Add, string chk_Role_Edit, string chk_Role_Delete, string chk_Role_Audit, string chk_Function_View, string chk_Function_Add, string chk_Function_Edit, string chk_Function_Delete, string chk_Function_Audit, object objUserInfo) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { RoleInfo objRoleInfo = new RoleInfo(); objRoleInfo.RoleID = RoleID; objRoleInfo.RoleName = RoleName; objRoleInfo.IsActive = isActive == "Y"; objRoleInfo.IsOnlyForModerateUsers = isOnlyForModerateUsers == "Y"; objRoleInfo.Customer_View = chk_Customer_View == "Y"; objRoleInfo.Customer_Add = chk_Customer_Add == "Y"; objRoleInfo.Customer_Edit = chk_Customer_Edit == "Y"; objRoleInfo.Customer_Delete = chk_Customer_Delete == "Y"; objRoleInfo.Customer_Audit = chk_Customer_Audit == "Y"; objRoleInfo.Product_View = chk_Product_View == "Y"; objRoleInfo.Product_Add = chk_Product_Add == "Y"; objRoleInfo.Product_Edit = chk_Product_Edit == "Y"; objRoleInfo.Product_Delete = chk_Product_Delete == "Y"; objRoleInfo.Product_Audit = chk_Product_Audit == "Y"; objRoleInfo.Organization_View = chk_Organization_View == "Y"; objRoleInfo.Organization_Add = chk_Organization_Add == "Y"; objRoleInfo.Organization_Edit = chk_Organization_Edit == "Y"; objRoleInfo.Organization_Delete = chk_Organization_Delete == "Y"; objRoleInfo.Organization_Audit = chk_Organization_Audit == "Y"; objRoleInfo.Branch_View = chk_Branch_View == "Y"; objRoleInfo.Branch_Add = chk_Branch_Add == "Y"; objRoleInfo.Branch_Edit = chk_Branch_Edit == "Y"; objRoleInfo.Branch_Delete = chk_Branch_Delete == "Y"; objRoleInfo.Branch_Audit = chk_Branch_Audit == "Y"; objRoleInfo.Role_View = chk_Role_View == "Y"; objRoleInfo.Role_Add = chk_Role_Add == "Y"; objRoleInfo.Role_Edit = chk_Role_Edit == "Y"; objRoleInfo.Role_Delete = chk_Role_Delete == "Y"; objRoleInfo.Role_Audit = chk_Role_Audit == "Y"; objRoleInfo.Function_View = chk_Function_View == "Y"; objRoleInfo.Function_Add = chk_Function_Add == "Y"; objRoleInfo.Function_Edit = chk_Function_Edit == "Y"; objRoleInfo.Function_Delete = chk_Function_Delete == "Y"; objRoleInfo.Function_Audit = chk_Function_Audit == "Y"; objRoleInfo.Category_View = chk_Category_View == "Y"; objRoleInfo.Category_Add = chk_Category_Add == "Y"; objRoleInfo.Category_Edit = chk_Category_Edit == "Y"; objRoleInfo.Category_Delete = chk_Category_Delete == "Y"; objRoleInfo.Category_Audit = chk_Category_Audit == "Y"; objRoleInfo.Bill_View = chk_Bill_View == "Y"; objRoleInfo.Bill_Add = chk_Bill_Add == "Y"; objRoleInfo.Bill_Edit = chk_Bill_Edit == "Y"; objRoleInfo.Bill_Delete = chk_Bill_Delete == "Y"; objRoleInfo.Bill_Audit = chk_Bill_Audit == "Y"; objRoleInfo.Language_View = chk_Language_View == "Y"; objRoleInfo.Language_Add = chk_Language_Add == "Y"; objRoleInfo.Language_Edit = chk_Language_Edit == "Y"; objRoleInfo.Language_Delete = chk_Language_Delete == "Y"; objRoleInfo.Language_Audit = chk_Language_Audit == "Y"; objRoleInfo.DefineLanguage_View = chk_DefineLanguage_View == "Y"; objRoleInfo.DefineLanguage_Add = chk_DefineLanguage_Add == "Y"; objRoleInfo.DefineLanguage_Edit = chk_DefineLanguage_Edit == "Y"; objRoleInfo.DefineLanguage_Delete = chk_DefineLanguage_Delete == "Y"; objRoleInfo.DefineLanguage_Audit = chk_DefineLanguage_Audit == "Y"; objRoleInfo.StaticValue_View = chk_StaticValue_View == "Y"; objRoleInfo.StaticValue_Add = chk_StaticValue_Add == "Y"; objRoleInfo.StaticValue_Edit = chk_StaticValue_Edit == "Y"; objRoleInfo.StaticValue_Delete = chk_StaticValue_Delete == "Y"; objRoleInfo.StaticValue_Audit = chk_StaticValue_Audit == "Y"; objRoleInfo.Terms_View = chk_Terms_View == "Y"; objRoleInfo.Terms_Add = chk_Terms_Add == "Y"; objRoleInfo.Terms_Edit = chk_Terms_Edit == "Y"; objRoleInfo.Terms_Delete = chk_Terms_Delete == "Y"; objRoleInfo.Terms_Audit = chk_Terms_Audit == "Y"; objRoleInfo.UserRegistered_View = chk_UserRegistered_View == "Y"; objRoleInfo.UserRegistered_Add = chk_UserRegistered_Add == "Y"; objRoleInfo.UserRegistered_Edit = chk_UserRegistered_Edit == "Y"; objRoleInfo.UserRegistered_Delete = chk_UserRegistered_Delete == "Y"; objRoleInfo.UserRegistered_Audit = chk_UserRegistered_Audit == "Y"; objRoleInfo.UserModerate_View = chk_UserModerate_View == "Y"; objRoleInfo.UserModerate_Add = chk_UserModerate_Add == "Y"; objRoleInfo.UserModerate_Edit = chk_UserModerate_Edit == "Y"; objRoleInfo.UserModerate_Delete = chk_UserModerate_Delete == "Y"; objRoleInfo.UserModerate_Audit = chk_UserModerate_Audit == "Y"; if (iGstSvc.Save_Role(isDelete == "Y", objRoleInfo, (UserInfo)Session["UserDetails"], out ErrorMessage)) { return(Json("Ok", JsonRequestBehavior.AllowGet)); } } return(Json(ErrorMessage, JsonRequestBehavior.AllowGet)); }
public ActionResult GetList_ProductForDropdownlist() { if (Session["ProductList"] != null && ((List <ProductInfo>)Session["ProductList"]).Count > 0) { return(Json((List <ProductInfo>)Session["ProductList"], JsonRequestBehavior.AllowGet)); } else { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { if (Session["Language"] == null) { Session["Language"] = 0; } if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null) { string OrganizationCode = ""; OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim(); List <ProductInfo> list = new Product_Svc.ProductServiceClient().GetList_ProductDropdownlist("", "", false, OrganizationCode, "", false, Session["Language"].ToString()); if (list != null && list.Count > 0) { Session["ProductList"] = list; return(Json(list, JsonRequestBehavior.AllowGet)); } else { //return Json(new HttpStatusCodeResult(410, "You have to select your products from Product/ service page."), JsonRequestBehavior.AllowGet); return(new HttpStatusCodeResult(410, "You have to select your products from Product/ service page.")); } } else if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "M") { List <ProductInfo> list = new Product_Svc.ProductServiceClient().GetList_ProductDropdownlist("", "", false, "", "", false, Session["Language"].ToString()); if (list != null && list.Count > 0) { Session["ProductList"] = list; return(Json(list, JsonRequestBehavior.AllowGet)); } else { //return Json(new HttpStatusCodeResult(410, "There some problem arrised in product listing."), JsonRequestBehavior.AllowGet); return(new HttpStatusCodeResult(410, "There some problem arrised in product listing.")); } } else { List <ProductInfo> list = new Product_Svc.ProductServiceClient().GetList_ProductDropdownlist("", "", false, "", "", false, Session["Language"].ToString()); if (list != null && list.Count > 0) { Session["ProductList"] = list; return(Json(list, JsonRequestBehavior.AllowGet)); } else { return(Json(new HttpStatusCodeResult(410, "There some problem arrised in product listing."), JsonRequestBehavior.AllowGet)); } } } } }
public System.Data.DataSet GetDataSet_Excel(HttpPostedFileBase file, out string ErrorMessage) { using (iGst_Svc.GSTServiceClient iGstSvc = new iGst_Svc.GSTServiceClient()) { System.Data.DataSet ds = null; ErrorMessage = ""; try { System.Data.OleDb.OleDbConnection conn = null; System.Data.OleDb.OleDbCommand cmd = null; System.Data.OleDb.OleDbDataAdapter da = null; string TableName = "", ConnectionString = ""; var fileName = System.IO.Path.GetFileName(file.FileName); var path = System.IO.Path.Combine(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["UploadDataPath"].ToString()), fileName); switch (System.IO.Path.GetExtension(path).Trim().ToUpper()) { case ".XLS": ConnectionString = string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["Excel03ConnStr"].ConnectionString, path); break; case ".XLSX": ConnectionString = string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["Excel07ConnStr"].ConnectionString, path); break; default: ErrorMessage = "Please select a valid excel file"; break; } if (ErrorMessage.Trim().Length == 0) { try { try { file.SaveAs(path); } catch (Exception ex) { Common.ErrorLog.LogErrors_Comments(ex.Message, "Master Page Controller", "Excel upload - Saveas", "Error"); ErrorMessage = "Problem in saving file:" + ex.Message; return(null); } try { conn = new System.Data.OleDb.OleDbConnection(string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["Excel15ConnStr"].ConnectionString, path)); conn.Open(); } catch { try { conn = new System.Data.OleDb.OleDbConnection(string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["Excel14ConnStr"].ConnectionString, path)); conn.Open(); } catch { try { conn = new System.Data.OleDb.OleDbConnection(string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["Excel13ConnStr"].ConnectionString, path)); conn.Open(); } catch { try { conn = new System.Data.OleDb.OleDbConnection(string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["Excel07ConnStr"].ConnectionString, path)); conn.Open(); } catch { try { conn = new System.Data.OleDb.OleDbConnection(string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["Excel03ConnStr"].ConnectionString, path)); conn.Open(); } catch (Exception ex) { Common.ErrorLog.LogErrors_Comments(ex.Message, "Master Page Controller", "Excel upload - Connection", "Error"); ErrorMessage = "Problem in saving file:" + ex.Message; return(null); } } } } } try { TableName = conn.GetSchema("Tables").Rows[0]["TABLE_NAME"].ToString(); cmd = new System.Data.OleDb.OleDbCommand(@"SELECT * FROM [" + TableName + "]", conn); da = new System.Data.OleDb.OleDbDataAdapter(cmd); ds = new System.Data.DataSet(); da.Fill(ds); da.Dispose(); cmd.Dispose(); conn.Dispose(); return(ds); } catch (Exception ex) { Common.ErrorLog.LogErrors_Comments(ex.Message, "Master Page Controller", "Excel upload - GetDataSet", "Error"); ErrorMessage = "Inner Problem in reading file"; return(null); } } catch (Exception ex) { Common.ErrorLog.LogErrors_Comments(ex.Message, "Master Page Controller", "Excel upload - GetDataSet", "Error"); ErrorMessage = "Problem in reading file"; return(null); } } if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } } catch (Exception ex) { ErrorMessage = "Problem in reading file" + ex.Message; return(null); } return(null); } }