public string CreateModelItem(string ModelItemEntity) { clstbItemMaster PatientMasterJson = JsonConvert.DeserializeObject <clstbItemMaster>(ModelItemEntity); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_tbPatientMasterAdd"; cmd.CommandType = CommandType.StoredProcedure; // Use base class' connection object _mainConnection = SqlHelper.GetConnection(); _mainConnection.Open(); cmd.Connection = _mainConnection; try { //cmd.Parameters.Add(new SqlParameter("@fldModuleItemID", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, "")); //cmd.Parameters.Add(new SqlParameter("@fldTitle", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, PatientMasterJson.FName)); //cmd.Parameters.Add(new SqlParameter("@ConsultDoctorIDF", SqlDbType.Int, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, PatientMasterJson.ConsultDoctorIDF)); cmd.Parameters.Add(new SqlParameter("@ReturnID", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, 0)); cmd.Parameters.Add(new SqlParameter("@PatientReturnID", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, 0)); // Execute query. int j = cmd.ExecuteNonQuery(); int returnID = Common.ConvertDBNullToInt32(cmd.Parameters["@ReturnID"].Value.ToString()); int PatientReturnID = Common.ConvertDBNullToInt32(cmd.Parameters["@PatientReturnID"].Value.ToString()); return(returnID.ToString() + ":" + j.ToString() + ":" + PatientReturnID.ToString()); } catch (Exception ex) { return("CreateItem::Insert::Error occured. Error message:" + ex.Message); } finally { cmd.Dispose(); } }
private static List <clstbItemMaster> ConvertDataSetToList(DataSet ds, int pageNumber = 1, int pageSize = 10) { try { if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { return(new List <clstbItemMaster>()); } List <clstbItemMaster> lstRoles = new List <clstbItemMaster>(); foreach (DataRow dr in ds.Tables[0].Rows) { clstbItemMaster E = new clstbItemMaster(); if (dr.Table.Columns.Contains("fldModuleItemID")) { E.fldModuleItemID = Convert.ToInt32(dr["fldModuleItemID"]); } if (dr.Table.Columns.Contains("fldTitle")) { E.fldTitle = Convert.ToString(dr["fldTitle"]); } //if (pageNumber != 0 && pageSize != 0) //{ // E.CurrentPage = pageNumber; // E.PageSize = pageSize; //} lstRoles.Add(E); } return(lstRoles); } catch { return(new List <clstbItemMaster>()); } }