public ActionResult InsertUpdateOIAutoAcceptance(OIAutoAcceptanceEntity obj)
{
string MatchGradeValue = "A,B,F,X,Z";
obj.MG_Company = obj.MG_Company.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_Company.Contains("#") ? "#" : obj.MG_Company);
obj.MG_StreetNo = obj.MG_StreetNo.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_StreetNo.Contains("#") ? "#" : obj.MG_StreetNo);
obj.MG_StreetName = obj.MG_StreetName.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_StreetName.Contains("#") ? "#" : obj.MG_StreetName);
obj.MG_City = obj.MG_City.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_City.Contains("#") ? "#" : obj.MG_City);
obj.MG_State = obj.MG_State.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_State.Contains("#") ? "#" : obj.MG_State);
obj.MG_PostalCode = obj.MG_PostalCode.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_PostalCode.Contains("#") ? "#" : obj.MG_PostalCode);
obj.MG_Phone = obj.MG_Phone.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_Phone.Contains("#") ? "#" : obj.MG_Phone);
obj.MG_Webdomain = obj.MG_Webdomain.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_Webdomain.Contains("#") ? "#" : obj.MG_Webdomain);
obj.MG_Country = obj.MG_Country.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_Country.Contains("#") ? "#" : obj.MG_Country);
obj.MG_EIN = obj.MG_EIN.Replace(" ", "") == MatchGradeValue ? "#" : (obj.MG_EIN.Contains("#") ? "#" : obj.MG_EIN);
OIAutoAcceptanceFacade fac = new OIAutoAcceptanceFacade(this.CurrentClient.ApplicationDBConnectionString);
try
{
int result = fac.InsertUpdateAutoAcceptanceRules(obj);
if (obj.RuleId > 0)
{
return(Json(new { result = true, message = CommonMessagesLang.msgCommanUpdateMessage }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = true, message = CommonMessagesLang.msgCommanInsertMessage }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { result = true, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
internal OIAutoAcceptanceEntity GetAutoAcceptanceRuleById(int RuleId)
{
OIAutoAcceptanceEntity results = new OIAutoAcceptanceEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "OI.GetAutoAcceptanceRuleById";
sproc.StoredProceduresParameter.Add(GetParam("@RuleId", RuleId.ToString(), SQLServerDatatype.IntDataType));
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
OIAutoAcceptanceAdapter ta = new OIAutoAcceptanceAdapter();
foreach (DataRow rw in dt.Rows)
{
results = ta.AdaptItem(rw);
}
}
}
catch (Exception)
{
throw;
}
return(results);
}
internal void DeleteAutoAcceptance(string RuleId)
{
OIAutoAcceptanceEntity results = new OIAutoAcceptanceEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "OI.DeleteOIAutoAcceptanceRules";
sproc.StoredProceduresParameter.Add(GetParam("@RuleId", RuleId.ToString(), SQLServerDatatype.IntDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (Exception)
{
throw;
}
}
public ActionResult InsertUpdateOIAutoAcceptance(string Parameters)
{
int RuleId = 0;
if (!string.IsNullOrEmpty(Parameters))
{
Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase);
RuleId = Convert.ToInt32(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 0, 1));
}
OIAutoAcceptanceFacade fac = new OIAutoAcceptanceFacade(this.CurrentClient.ApplicationDBConnectionString);
OIAutoAcceptanceEntity model = new OIAutoAcceptanceEntity();
if (RuleId > 0)
{
model = fac.GetAutoAcceptanceRuleById(RuleId);
}
return(View("~/Views/OI/OISetting/InsertUpdateOIAutoAcceptance.cshtml", model));
}
internal int InsertUpdateAutoAcceptanceRules(OIAutoAcceptanceEntity obj)
{
int result = 0;
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "OI.InsertUpdateAutoAcceptanceRules";
sproc.StoredProceduresParameter.Add(GetParam("@ConfidenceCodeMin", obj.ConfidenceCodeMin.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ConfidenceCodeMax", obj.ConfidenceCodeMax.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_Company", obj.MG_Company.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_StreetNo", obj.MG_StreetNo.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_StreetName", obj.MG_StreetName.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_City", obj.MG_City.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_State", obj.MG_State.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_PostalCode", obj.MG_PostalCode.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_Phone", obj.MG_Phone.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_Webdomain", obj.MG_Webdomain.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_Country", obj.MG_Country.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MG_EIN", obj.MG_EIN.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MDP_Company", obj.MDP_Company.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MDP_Webdomain", obj.MDP_Webdomain.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Score_Company", obj.Score_Company.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Score_StreetName", obj.Score_StreetName.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Tags", string.IsNullOrEmpty(obj.Tags) ? "" : obj.Tags.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CountryGroupId", obj.CountryGroupId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AcceptActiveOnly", obj.AcceptActiveOnly.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PreferLinkedRecord", obj.PreferLinkedRecord.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ExcludeFromAutoAccept", obj.ExcludeFromAutoAccept.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@RuleId", obj.RuleId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@UserId", obj.UserId.ToString(), SQLServerDatatype.IntDataType));
result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception)
{
throw;
}
return(result);
}
public int InsertUpdateAutoAcceptanceRules(OIAutoAcceptanceEntity obj)
{
return(rep.InsertUpdateAutoAcceptanceRules(obj));
}
