public DataBaseResultSet SaveDiseaseMaster <T>(T objData) where T : class, IModel, new() { DiseaseMaster obj = objData as DiseaseMaster; string sQuery = "sprocDiseaseMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("DiseaseCode", "DiseaseCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DiseaseCode)); list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode)); list.Add(SqlConnManager.GetConnParameters("DiseaseName", "DiseaseName", 50, GenericDataType.String, ParameterDirection.Input, obj.DiseaseName)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode)); list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public ActionResult DeleteConfirmed(int id) { DiseaseMaster diseaseMaster = db.DiseaseMasters.Find(id); db.DiseaseMasters.Remove(diseaseMaster); db.SaveChanges(); return(RedirectToAction("Index")); }
public void GetListDiseaseMaster <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListDiseaseMaster"; DiseaseMaster objData = objFilter as DiseaseMaster; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("DiseaseCode", "DiseaseCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.DiseaseCode)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDiseaseMasterDataFromReader, ref listData); }
private void FillDiseaseMasterDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new() { while (DbReader.Read()) { T obj = new T(); DiseaseMaster objData = obj as DiseaseMaster; obj.FillDataFromDB(DbReader); listData.Add(obj); } }
public ActionResult Edit([Bind(Include = "Id,Disease")] DiseaseMaster diseaseMaster) { if (ModelState.IsValid) { db.Entry(diseaseMaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(diseaseMaster)); }
public ActionResult Create([Bind(Include = "Id,Disease")] DiseaseMaster diseaseMaster) { if (ModelState.IsValid) { db.DiseaseMasters.Add(diseaseMaster); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(diseaseMaster)); }
// GET: DiseaseMasters/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DiseaseMaster diseaseMaster = db.DiseaseMasters.Find(id); if (diseaseMaster == null) { return(HttpNotFound()); } return(View(diseaseMaster)); }