public List <M_Reject> getReasons(string RejectCode)
{
try
{
List <M_Reject> lstreason = new List <M_Reject>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getRejectReasonsResult> lst = datacontext._getRejectReasons(RejectCode);
foreach (_getRejectReasonsResult result in lst)
{
M_Reject r = new M_Reject();
r.Reject_ReasonId = result.RejectCode;
r.Reject_ReasonName = result.ReasonName;
lstreason.Add(r);
}
}
return(lstreason);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public ActionResult NewRejectReason(M_Reject Model)
{
if (Model.Reject_ReasonName == null || Model.Reject_ReasonCategory == null)
{
Model.IsActive = "Y";
return(PartialView("P_NewRejectReason", Model));
}
string result = "Error";
try
{
if (Model.Reject_ReasonId == null)
{
if (objSettings.RejectR_NewRejectReason(Model))
{
result = "Success";
}
}
else
{
if (objSettings.RejectR_UpdateRejectReason(Model))
{
result = "Success";
}
}
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public List <M_Reject> RejectR_getRejectReasons(string RCategory, string IsActive)
{
try
{
List <M_Reject> lstR = new List <M_Reject>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getRejectReasons_ListResult> lst = datacontext._getRejectReasons_List(RCategory, IsActive);
foreach (_getRejectReasons_ListResult result in lst)
{
M_Reject R = new M_Reject();
R.Reject_ReasonCategory = result.Category;
R.Reject_ReasonName = result.ReasonName;
R.Reject_ReasonId = result.RejectCode;
R.Createdby = result.CreatedBy;
R.CreatedDate = Convert.ToDateTime(result.CreatedDate);
lstR.Add(R);
}
}
return(lstR);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public JsonResult Reject_SDocument(M_Reject Model)
{
String result = "Error";
bool r = false;
r = objSDApprv.RejectSDocument(Model.Rejecting_ID,
_session.User_Id,
Model.Reject_ReasonId);
if (r)
{
result = "Success";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteRejectReason(M_Reject Model)
{
string result = "Error";
try
{
if (objSettings.RejectR_DeleteRejectReason(Model))
{
result = "Success";
}
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool RejectR_DeleteRejectReason(M_Reject sd)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
datacontext._setDeleteRejectReason(sd.Reject_ReasonId);
datacontext.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(false);
}
}
public JsonResult RejectCCustomer(M_Reject Model)
{
string result = "Error";
try
{
result = CustomerOBj.SetRejectCustomerChildRequest(Model);
if (result != null)
{
result = "Success";
}
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult NewRejectReason(string Rid, string rrc, string Rname)
{
Rejectitem objReject = new Rejectitem();
List <M_RejectCategory> RCategory = objReject.getReasonCategories();
ViewBag.Bag_RejectReasonsCat = new SelectList(RCategory, "RejectCategoryId", "RejectCategoryName");
M_Reject Ex = new M_Reject();
if (Rid != "")
{
Ex.Reject_ReasonId = Rid;
Ex.Reject_ReasonName = Rname.Replace("_", " ");
Ex.Reject_ReasonCategory = rrc;
return(PartialView("P_NewRejectReason", Ex));
}
//Ex.IsActive = "Y";
return(PartialView("P_NewRejectReason"));
}
public bool RejectR_NewRejectReason(M_Reject sd)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
B_RecordSequence seqmanager = new B_RecordSequence();
Int64 rr = seqmanager.getNextSequence("RejectCode", datacontext);
string rrc = "RRC" + rr.ToString();
datacontext._setNewRejectReason(rrc, sd.Reject_ReasonCategory, sd.Reject_ReasonName, sd.Createdby, "Y");
datacontext.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(false);
}
}
public string SetRejectCustomerChildRequest(M_Reject pr)
{
string result = "Error";
try
{
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
dbContext._setCustomerChildReject(pr.Rejecting_ID);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
//MailSender Mail = new MailSender();
//Mail.SendEmail(pr.Email_, "NCE Registration Approval", Parent_Rejected, " ");
}
catch (Exception ex)
{
ErrorLog.LogError("B_Customer", ex);
dbContext.Transaction.Rollback();
return(result);
}
finally
{
dbContext.Connection.Close();
}
}
return(result);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(result);
}
}
public JsonResult Reject_Certificate(M_Reject Model)
{
String result = "Error";
bool r = false;
if (Model.Ctype_.Equals("W"))
{
r = objAprv.RejectCertificate(Model.Rejecting_ID,
_session.User_Id,
Model.Reject_ReasonId);
}
else if (Model.Ctype_.Equals("U"))
{
r = objAprv.RejectUBCertificate(Model.Rejecting_ID,
_session.User_Id,
Model.Reject_ReasonId);
}
if (r)
{
result = "Success";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
