public ActionResult Save_CurrencyOrganization(string isOnlyDelete, string OrganizationproductId, string CurrencyId, 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 (Currency_Svc.CurrencyServiceClient iGstSvc = new Currency_Svc.CurrencyServiceClient())
{
// Modified on [3rd August 2019] by [Partha] cause [Giving NULL reference exception
// when Organisation Code is null] - Start
if (OrganizationproductId == null)
{
OrganizationproductId = "";
}
// End: Modified on [3rd August 2019]
CurrencyOrganiztionInfo objProduct = new CurrencyOrganiztionInfo();
objProduct.OrganizationproductId = OrganizationproductId.Trim().Length == 0 ? 0 : Convert.ToInt32(OrganizationproductId.Trim());
objProduct.OrganizationCode = OrganizationCode;
objProduct.CurrencyId = CurrencyId;
if (iGstSvc.Save_CurrencyOrganization(isOnlyDelete.Trim().ToUpper() == "Y", objProduct, ((UserInfo)Session["UserDetails"]), out ErrorMessage))
{
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
}
return(Json(ErrorMessage, JsonRequestBehavior.AllowGet));
}
public static bool Save_CurrencyOrganization(bool isOnlyDelete, CurrencyOrganiztionInfo obj, UserInfo objUserInfo, out string errormsg)
{
errormsg = "";
bool flag = false;
#region Validations
if (!Validations.ValidateDataType(obj.OrganizationCode, Validations.ValueType.AlphaNumericSpecialChar, false, "Organization", out errormsg))
{
return(false);
}
if (!Validations.ValidateDataType(obj.CurrencyId, Validations.ValueType.Alphabet, true, "Currency Info", out errormsg))
{
return(false);
}
#endregion
using (DBHelper dbhlper = new DBHelper("[spMAPOrganizationcurrencySave]", true))
{
DBHelper.AddPparameter("@OrganizationCurrencyId", obj.OrganizationproductId, DBHelper.param_types.BigInt);
DBHelper.AddPparameter("@CurrencyId", obj.CurrencyId.Trim().Length > 0 ? obj.CurrencyId : "", DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@OrganizationCode", obj.OrganizationCode.Trim(), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@UserCode", objUserInfo.UserCode.ToString().Trim(), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@isOnlyDelete", (isOnlyDelete ? "Y" : "N"), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@NewDatauniqueID", "", DBHelper.param_types.Varchar, 50, DBHelper.param_direction.Output);
DBHelper.AddPparameter("@ErrorMessage", errormsg, DBHelper.param_types.Varchar, 500, DBHelper.param_direction.Output);
return(DBHelper.Execute_NonQuery(out errormsg));
}
}
public static List <CurrencyOrganiztionInfo> GetDetails_CurrencyOrganization(string OrganizationproductId, string CurrencyId, string OrganizationCode)
{
using (DBHelper dbhlper = new DBHelper("[spMAPOrganizationcurrencyGet]"))
{
List <CurrencyOrganiztionInfo> list = new List <CurrencyOrganiztionInfo>();
DBHelper.AddPparameter("@Mode", 1);
DBHelper.AddPparameter("@OrganizationCurrencyId", OrganizationproductId.Trim().Length > 0 ? Convert.ToInt32(OrganizationproductId) : 0);
DBHelper.AddPparameter("@CurrencyId", CurrencyId);
DBHelper.AddPparameter("@OrganizationCode", OrganizationCode);
using (DataSet ds = DBHelper.Execute_Query())
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
CurrencyOrganiztionInfo obj = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
obj = new CurrencyOrganiztionInfo();
obj.OrganizationproductId = dr["OrganizationCurrencyId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["OrganizationCurrencyId"]);
obj.CurrencyId = dr["CurrencyId"].ToString();
obj.Symbol = dr["symbol"].ToString();
obj.CurrencyName = dr["name"].ToString();
obj.isSelected = dr["isExist"].ToString().Trim().ToUpper() == "Y";
list.Add(obj);
}
return(list);
}
}
}
return(null);
}
public bool Save_CurrencyOrganization(bool isOnlyDelete, CurrencyOrganiztionInfo obj, UserInfo objUserInfo, out string errormsg)
{
return(wsCurrency.Save_CurrencyOrganization(isOnlyDelete, obj, objUserInfo, out errormsg));
}
