public ActionResult TPADocumentMaster(TPADocumentMaster obj, FormCollection fc) { try { if (blTPA.Save(obj)) { if (obj.LetterID > 0) { ModelState.Clear(); TempData["Msg"] = "TPA Covering Letter Updated Successfully !"; return(RedirectToAction("TPADocumentMaster", "TPADocumentMaster")); } else { ModelState.Clear(); TempData["Msg"] = "TPA Covering Letter Saved Successfully !"; return(RedirectToAction("TPADocumentMaster", "TPADocumentMaster")); } } return(RedirectToAction("TPADocumentMaster", "TPADocumentMaster")); } catch (Exception ex) { return(RedirectToAction("TPADocumentMaster", "TPADocumentMaster")); } }
public bool Save(TPADocumentMaster obj) { try { Connect(); SqlCommand cmd = new SqlCommand("IUOrganizationTemplate", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationId); if (obj.LetterID == 0) { cmd.Parameters.AddWithValue("@OrganizationTemplateID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@OrganizationTemplateID", obj.LetterID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@Naration", obj.DocumentID); cmd.Parameters.AddWithValue("@Naration1", ""); cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }