public DataSet SelectByID(DispositionModel oClass)
{
strSql = "SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
return(Select(strSql));
}
public void UpdateData(string user, DispositionModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
COLUMN_DNAME + " = '" + oClass.DispositionName.Replace("'", "") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
public void InsertData(string currUser, DispositionModel oClass)
{
strSql = strSql + "INSERT INTO " + TABLE_NAME + " (" +
COLUMN_DNAME + ", " +
"created_by, created_date, updated_by, updated_date) ";
strSql = strSql + "values ('" +
oClass.DispositionName.Replace("'", "") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
") ";
SaveData(strSql);
}
private void LoaDispositions()
{
var dispositionModel = new DispositionModel();
var dispositionDal = new DispositionDAL();
oDs = new DataSet();
//medModel.ItemName = SearchMed.Value;
////oDs = medDal.SeachData(medModel);
oDs = dispositionDal.SelectAll();
var dispostionTable = new DataTable();
dispostionTable.Columns.Add("id");
dispostionTable.Columns.Add("dname");
var medsRow = dispostionTable.NewRow();
medsRow[0] = 0;
medsRow[1] = "--Select Disposition--";
dispostionTable.Rows.Add(medsRow);
if (oDs != null)
{
if (oDs.Tables[0].Rows.Count > 0)
{
for (int i = 0; i <= oDs.Tables[0].Rows.Count - 1; i++)
{
var resultFinal = dispostionTable.NewRow();
resultFinal[0] = oDs.Tables[0].Rows[i]["id"].ToString();
resultFinal[1] = oDs.Tables[0].Rows[i]["dname"].ToString();
dispostionTable.Rows.Add(resultFinal);
}
}
}
ddlDisposition.DataSource = dispostionTable;
ddlDisposition.DataValueField = "id";
ddlDisposition.DataTextField = "dname";
ddlDisposition.DataBind();
}
public List <DispositionModel> getDisposition()
{
try
{
DBResource newConnection = new DBResource();
List <DispositionModel> listModel = new List <DispositionModel>();
DispositionModel dispositionModel;
using (SqlConnection myConnection = new SqlConnection(newConnection.connectionString.ToString()))
{
string query = "dbo.GetDisposition";
SqlCommand cmd = new SqlCommand(query, myConnection);
myConnection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
dispositionModel = new DispositionModel();
dispositionModel.dispositionId = Convert.ToInt32(dr["disposition_id"]);
dispositionModel.disposition = dr["disposition"].ToString();
listModel.Add(dispositionModel);
}
myConnection.Close();
}
}
return(listModel);
}
catch (Exception ex)
{
throw ex;
}
}