public M_NCETemplate getTemplateData(string TempID, String IsActive) { try { M_NCETemplate th = new M_NCETemplate(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <DCISgetTemplateHeaderResult> lst = datacontext.DCISgetTemplateHeader(TempID, IsActive, "%"); foreach (DCISgetTemplateHeaderResult result in lst) { th.Template_Id = result.TemplateId; th.Template_Name = result.TemplateName; th.Description_ = result.Description; th.Img_Url = result.ImgUrl; th.Is_Active = result.IsActive; } } return(th); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public JsonResult SetClientTemplate(M_NCETemplate Model) { string result = "Error"; try { result = CustomerOBj.SetChildTemplate(Model); if (result != null) { result = "Success"; } } catch (Exception Ex) { ErrorLog.LogError(Ex); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public string SetChildTemplate(M_NCETemplate pr) { try { string result = "Error"; using (DBLinqDataContext dbContext = new DBLinqDataContext()) { dbContext.Connection.ConnectionString = Connection_; dbContext.Connection.Open(); try { dbContext.Transaction = dbContext.Connection.BeginTransaction(); dbContext._setCutomerClientTemplate(pr.ClientID_, pr.Template_Id); dbContext.SubmitChanges(); dbContext.Transaction.Commit(); //MailSender Mail = new MailSender(); //Mail.SendEmail(pr.ContactPersonEmail, "NCE Registration Approval", Parent_Approved + " Your Customer Code is : " + ParentCID, " "); return(result = "Sucess"); //Email Send function needed } catch (Exception ex) { ErrorLog.LogError("B_Customer", ex); dbContext.Transaction.Rollback(); return(result); } finally { dbContext.Connection.Close(); } } } catch (Exception ex) { ErrorLog.LogError(ex); return("Exception"); } }