How to call stored procedure in MVC Application

-
How to call stored procedure in MVC Application


public int UpdateFinalOutcome(bool isDeathCertificate, bool isCornerReferralComplete)
{
int retVal = 0;
SqlCommand dbCommand = new SqlCommand("usp_UpsertFinalOutcome", connection);
            try
            {
                dbCommand.CommandType = CommandType.StoredProcedure;
                dbCommand.Parameters.AddWithValue("@isDeathCertificate", isDeathCertificate);
                dbCommand.Parameters.AddWithValue("@isCornerReferralComplete", isCornerReferralComplete);
retVal = dbCommand.ExecuteNonQuery();
catch (Exception ex)
            {
                LogException(ex.Message, this.ToString(), "ValidateUser", System.DateTime.Now);
            }
            return retVal;
        }

public List<clsPatientDetails> GetPatientDetails(int? patientID, int userID)
        {
            var connection = GetConnection();
            SqlDataReader dbReader = null;
            List<clsPatientDetails> lstPatientDetails = new List<clsPatientDetails>();
            try
            {
                SqlCommand dbCmd = new SqlCommand("usp_GetPatientDashboardDetails", connection);
                dbCmd.CommandType = CommandType.StoredProcedure;
                if (patientID != null)
                    dbCmd.Parameters.AddWithValue("@PatientID", patientID);
                else
                    dbCmd.Parameters.AddWithValue("@PatientID", 0);
                dbCmd.Parameters.AddWithValue("@UserID", userID);

                dbReader = dbCmd.ExecuteReader();
                while (dbReader.Read())
                {
                    clsPatientDetails patientDashboard = new clsPatientDetails();
                    if (string.IsNullOrEmpty(dbReader["ID"].ToString()))
                        patientDashboard.ID = 0;
                    else
                        patientDashboard.ID = Convert.ToInt32(dbReader["ID"]);
                    if (string.IsNullOrEmpty(dbReader["PatientId"].ToString()))
                        patientDashboard.PatientId = "";
                    else
                        patientDashboard.PatientId = Convert.ToString(dbReader["PatientId"]);
                    if (string.IsNullOrEmpty(dbReader["DOB"].ToString()))
                        patientDashboard.DOB = "Pending";
                    else
                        patientDashboard.DOB = Convert.ToDateTime(dbReader["DOB"]).ToString("dd/MM/yyyy");
                   
                    lstPatientDetails.Add(patientDashboard);
                }
                LogException("After loop", this.ToString(), "ValidateUser", System.DateTime.Now);
            }
            catch (Exception ex)
            {
                LogException(ex.Message, this.ToString(), "ValidateUser", System.DateTime.Now);
            }
            finally
            {
                if (!dbReader.IsClosed)
                    dbReader.Close();
            }
            return lstPatientDetails;
        }

Comments

Post a Comment

Popular posts from this blog

Kendo Control(Dynamics)

-
Image
21. Kendo Button:             Write the below code in view                 <div>                     @( Html.Kendo().Button()    .Name( "btnShare" )   .Content( "Share" )   .HtmlAttributes( new  { type =  "button" , @class =  "btn btn-primary" ,      style =  "height:30px; width:120px; border-radius:0;padding: 3px;"  })                        .Events(e => e.Click( "btnShare_Click" ))                  ) </div> <script>      ...
Read more

Override Authorize Filters in MVC

-
Image
Override Authorize Filters in MVC Authorize Filter: It is to limit the access for a user or user specific to the role. Implementation of Override Authorize filters in MVC Step1: Add a controller and named it as HomeController Add [Authorize] attribute before an action or a controller based on the requirement. Suppose user want to restrict the access of particular controller but allow some of action of that controller. So just add [Authorize] before controller                using System; using System.Web.Mvc; using System.Web.Mvc.Filters; namespace WebApplication1.Controllers {     [ Authorize ]     public class HomeController : Controller     {     } } Step 2: Create a class and named it as OverrideAuthorizeAttribute which should inherit AuthorizeAttribute and Implements IOverrideFilter    public ...
Read more

Form Validation

-
Image
How to validate a form using Jquery Write the below code : < form action ="" id ="frmEnquiry" method ="post" novalidate ="novalidate">                 < p class ="your-para"> Your Name : </ p >                 < input type ="text" name ="Name" id ="Name" value ="" onfocus ="this .value= '' ; " onblur ="if ( this .value == '' ) { this .value = '' ;} ">                 < p class ="your-para"> Your Mail : </ p >                 < input type ="text" name ="Email" id ="Email" value ="" onfocus ="this .value= '' ; " onblur ="if ( this .value == '' ) { this .value = '' ;} ">        ...
Read more