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