public Int32 insertArticleContact(Models.MstArticleContact contact, String articleId) { try { Data.MstArticleContact newContact = new Data.MstArticleContact(); newContact.ArticleId = Convert.ToInt32(articleId); newContact.ContactPerson = contact.ContactPerson; newContact.ContactNumber = contact.ContactNumber; newContact.Remarks = contact.Remarks; db.MstArticleContacts.InsertOnSubmit(newContact); db.SubmitChanges(); return(newContact.Id); } catch { return(0); } }
public Int32 insertArticleContact(Models.MstArticleContact contact, String articleId) { try { Data.MstArticleContact newContact = new Data.MstArticleContact(); newContact.ArticleId = Convert.ToInt32(articleId); newContact.ContactPerson = contact.ContactPerson; newContact.ContactNumber = contact.ContactNumber; newContact.Remarks = contact.Remarks; db.MstArticleContacts.InsertOnSubmit(newContact); db.SubmitChanges(); return newContact.Id; } catch { return 0; } }
public HttpResponseMessage AddMoreContactInformation(Entities.MstArticleContact objContactInformation, String articleId) { try { String supplierDetailURL = "/Software/SupplierDetail"; String customerDetailURL = "/Software/CustomerDetail"; String currentAbsolutePath = HttpContext.Current.Request.UrlReferrer.AbsolutePath; var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currentUserId = currentUser.FirstOrDefault().Id; IQueryable <Data.MstUserForm> userForms = null; if (currentAbsolutePath.Equals(supplierDetailURL)) { userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("SupplierDetail") select d; } else { if (currentAbsolutePath.Equals(customerDetailURL)) { userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("CustomerDetail") select d; } else { userForms = null; } } if (userForms.Any()) { if (userForms.FirstOrDefault().CanAdd) { var article = from d in db.MstArticles where d.Id == Convert.ToInt32(articleId) select d; if (article.Any()) { if (!article.FirstOrDefault().IsLocked) { Data.MstArticleContact newContact = new Data.MstArticleContact { ArticleId = Convert.ToInt32(articleId), ContactPerson = objContactInformation.ContactPerson, ContactNumber = objContactInformation.ContactNumber, Remarks = objContactInformation.Remarks }; db.MstArticleContacts.InsertOnSubmit(newContact); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { if (currentAbsolutePath.Equals(supplierDetailURL)) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new contact information if the current supplier detail is locked.")); } else { if (currentAbsolutePath.Equals(customerDetailURL)) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new contact information if the current customer detail is locked.")); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "URL Not Found.")); } } } } else { if (currentAbsolutePath.Equals(supplierDetailURL)) { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current supplier details are not found in the server. Please add new supplier first before proceeding.")); } else { if (currentAbsolutePath.Equals(customerDetailURL)) { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current supplier details are not found in the server. Please add new supplier first before proceeding.")); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "URL Not Found.")); } } } } else { if (currentAbsolutePath.Equals(supplierDetailURL)) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new contact information in this supplier detail page.")); } else { if (currentAbsolutePath.Equals(customerDetailURL)) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new contact information in this customer detail page.")); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "URL Not Found.")); } } } } else { if (currentAbsolutePath.Equals(supplierDetailURL)) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this supplier detail page.")); } else { if (currentAbsolutePath.Equals(customerDetailURL)) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this customer detail page.")); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "URL Not Found.")); } } } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }