public static List<LanguageValueInfo> GetList_DataValueLanguageWise(string MasterTablePrefixs, string LanguageIds, bool IsActive) { using (DBHelper dbhlper = new DBHelper("[splangValuGet]")) { DBHelper.AddPparameter("@MasterIDField", ""); DBHelper.AddPparameter("@MasterTablePrefixs", MasterTablePrefixs); DBHelper.AddPparameter("@LanguageIds", LanguageIds); DBHelper.AddPparameter("@IsActive", ""); using (DataSet ds = DBHelper.Execute_Query()) { if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List<LanguageValueInfo> list = new List<LanguageValueInfo>(); LanguageValueInfo obj = null; foreach (DataRow dr in ds.Tables[0].Rows) { obj = new LanguageValueInfo(); obj.LanguageId = dr["LanguageID"].ToString(); obj.LanguageName = dr["LanguageName"].ToString(); obj.MasterFieldValue = dr["MasterFieldValue"].ToString(); obj.MasterIDField = dr["MasterIDField"].ToString(); obj.MasterTablePrefix = dr["MasterTablePrefix"].ToString(); if (obj.MasterTablePrefix == "CA") { obj.MasterTableName = "Category"; } else if (obj.MasterTablePrefix == "P") { obj.MasterTableName = "Product"; } obj.value = dr["value"].ToString(); list.Add(obj); } return list; } } } return null; }
public ActionResult Save_DataValueLanguageWise(string isOnlyDelete, string LanguageId, string value, string MasterTablePrefix, string MasterIDField, string IsActive) { using (Master_Svc.MasterServiceClient iGstSvc = new Master_Svc.MasterServiceClient()) { LanguageValueInfo objLanguage = new LanguageValueInfo(); objLanguage.LanguageId = LanguageId; objLanguage.value = value; objLanguage.MasterTablePrefix = MasterTablePrefix; objLanguage.MasterIDField = MasterIDField; objLanguage.IsActive = IsActive.Trim().ToUpper() == "Y"; if (iGstSvc.Save_DataValueLanguageWise(isOnlyDelete.Trim().ToUpper() == "Y", objLanguage, ((UserInfo)Session["UserDetails"]), out ErrorMessage)) { return(Json("Ok", JsonRequestBehavior.AllowGet)); } return(Json(ErrorMessage, JsonRequestBehavior.AllowGet)); } }
public static bool Save_DataValueLanguageWise(bool isOnlyDelete, LanguageValueInfo obj, UserInfo objUserInfo, out string errormsg) { errormsg = ""; #region Validations if (!Validations.ValidateDataType(obj.LanguageId, Validations.ValueType.Integer, true, "Language Id", out errormsg)) { return false; } #endregion using (DBHelper dbhlper = new DBHelper("[splangValuSave]", true)) { DBHelper.AddPparameter("@MasterIDField", obj.MasterIDField, DBHelper.param_types.Varchar); DBHelper.AddPparameter("@MasterTablePrefix", obj.MasterTablePrefix, DBHelper.param_types.Varchar); DBHelper.AddPparameter("@LanguageId", obj.LanguageId, DBHelper.param_types.Varchar); DBHelper.AddPparameter("@Value", obj.value, DBHelper.param_types.NVarchar); DBHelper.AddPparameter("@IsActive", (obj.IsActive ? "Y" : "N"), DBHelper.param_types.Varchar); DBHelper.AddPparameter("@isOnlyDelete", (isOnlyDelete ? 'Y' : 'N'), DBHelper.param_types.Varchar); 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 bool Save_DataValueLanguageWise(bool isOnlyDelete, LanguageValueInfo obj, UserInfo objUserInfo, out string errormsg) { return(wscalls.Save_DataValueLanguageWise(isOnlyDelete, obj, objUserInfo, out errormsg)); }