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>());
}
}
