public ActionResult GetList_LanguageCountryDropdownList() { if (System.Web.HttpContext.Current.Session["LanguageCountrtyList"] == null) { string CountryID = "0"; if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserID != null && ((UserInfo)Session["UserDetails"]).Country != null && ((UserInfo)Session["UserDetails"]).Country.Trim().Length > 0) { CountryID = ((UserInfo)Session["UserDetails"]).Country; } using (Master_Svc.MasterServiceClient iGstSvc = new Master_Svc.MasterServiceClient()) { List <LanguageCountryInfo> list = iGstSvc.GetList_LanguageCountry("", "", CountryID, "", true); if (list == null) { list = new List <LanguageCountryInfo>(); } LanguageCountryInfo obLanguage = new LanguageCountryInfo(); obLanguage.LanguageId = "0"; obLanguage.LanguageName = "English"; list.Insert(0, obLanguage); obLanguage = null; System.Web.HttpContext.Current.Session["LanguageCountrtyList"] = list; return(Json(list, JsonRequestBehavior.AllowGet)); } } else { return(Json((List <LanguageCountryInfo>)System.Web.HttpContext.Current.Session["LanguageCountrtyList"], JsonRequestBehavior.AllowGet)); } }
public ActionResult Save_LanguageCountry(string isOnlyDelete, string Id, string LanguageId, string CountryId, string Visibility, string Priority, string IsActive) { using (Master_Svc.MasterServiceClient iGstSvc = new Master_Svc.MasterServiceClient()) { LanguageCountryInfo objLanguage = new LanguageCountryInfo(); objLanguage.Id = Id == "" ? 0 : Convert.ToInt32(Id); objLanguage.LanguageId = LanguageId; objLanguage.CountryId = CountryId; objLanguage.Visibility = Visibility.Trim().ToUpper() == "Y"; objLanguage.Proirity = Priority == "" ? 0 : Convert.ToInt32(Priority); if (iGstSvc.Save_LanguageCountry(isOnlyDelete.Trim().ToUpper() == "Y", objLanguage, ((UserInfo)Session["UserDetails"]), out ErrorMessage)) { return(Json("Ok", JsonRequestBehavior.AllowGet)); } return(Json(ErrorMessage, JsonRequestBehavior.AllowGet)); } }
public static bool Save_LanguageCountry(bool isOnlyDelete, LanguageCountryInfo obj, UserInfo objUserInfo, out string errormsg) { errormsg = ""; #region Validations if (!Validations.ValidateDataType(obj.LanguageId, Validations.ValueType.Integer, true, "Language Id", out errormsg)) { return false; } if (!Validations.ValidateDataType(obj.CountryId, Validations.ValueType.Integer, true, "Countrry Id", out errormsg)) { return false; } #endregion using (DBHelper dbhlper = new DBHelper("[spLanguageCountrySave]", true)) { DBHelper.AddPparameter("@Id", obj.Id, DBHelper.param_types.BigInt); DBHelper.AddPparameter("@LanguageId", obj.LanguageId, DBHelper.param_types.BigInt); DBHelper.AddPparameter("@CountryId", obj.CountryId, DBHelper.param_types.BigInt); DBHelper.AddPparameter("@Visibility", (obj.Visibility ? "Y" : "N"), DBHelper.param_types.Varchar); DBHelper.AddPparameter("@Priority", obj.Proirity, DBHelper.param_types.BigInt); DBHelper.AddPparameter("@UserCode", objUserInfo.UserCode.ToString().Trim(), DBHelper.param_types.Varchar); DBHelper.AddPparameter("@ErrorMessage", errormsg, DBHelper.param_types.Varchar, 500, DBHelper.param_direction.Output); return DBHelper.Execute_NonQuery(out errormsg); } }
public static List<LanguageCountryInfo> GetList_LanguageCountry(string ID, string LanguageID, string CountryID, string Visibility, bool IsActive) { using (DBHelper dbhlper = new DBHelper("[spLanguageCountryGet]")) { DBHelper.AddPparameter("@Id", ID.Trim().Length > 0 ? ID : "0"); DBHelper.AddPparameter("@LanguageId", LanguageID); DBHelper.AddPparameter("@CountryId", CountryID); DBHelper.AddPparameter("@Visibility", Visibility); using (DataSet ds = DBHelper.Execute_Query()) { if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List<LanguageCountryInfo> list = new List<LanguageCountryInfo>(); LanguageCountryInfo obj = null; foreach (DataRow dr in ds.Tables[0].Rows) { obj = new LanguageCountryInfo(); obj.Id = Convert.ToInt32(dr["Id"]); obj.LanguageId = dr["LanguageId"].ToString(); obj.LanguageName = dr["LanguageName"].ToString(); obj.CountryId = dr["CountryId"].ToString(); obj.CountryName = dr["CountryName"].ToString(); obj.Visibility = dr["Visibility"].ToString() == "Y"; obj.Proirity = Convert.ToInt32(dr["Priority"].ToString()); list.Add(obj); } return list; } } } return null; }
public bool Save_LanguageCountry(bool isOnlyDelete, LanguageCountryInfo obj, UserInfo objUserInfo, out string errormsg) { return(wscalls.Save_LanguageCountry(isOnlyDelete, obj, objUserInfo, out errormsg)); }