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