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