public PagedList <CriticalCareModel> GetAllCriticalCaresPaginated(int skip, int take, string order, string where) { var criticalCares = new List <CriticalCareModel>(); var orderBy = string.IsNullOrEmpty(order) ? " order by cc.created_on desc " : order; var query = "select cc.*, cm.city_name from critical_care_master cc, city_master cm where cc.city_id = cm.city_id and cc.is_active='y' " + where + orderBy + " limit " + take + " offset " + skip; var rows = new DataAccessManager().ExecuteSelectQuery(query); if (rows != null && rows.Count > 0) { foreach (DataRow r in rows) { var criticalCare = new CriticalCareModel(); var props = typeof(CriticalCareModel).GetProperties(); foreach (var prop in props) { var ignore = Attribute.IsDefined(prop, typeof(IgnoreSelect)); if (!ignore) { var attribute = prop.GetCustomAttributes(typeof(DisplayNameAttribute), true).Cast <DisplayNameAttribute>().Single(); string displayName = attribute.DisplayName; var value = r[displayName]; var pType = prop.PropertyType; object v = null; if (pType == typeof(bool)) { v = value.ToString() == "y"; } else { v = value == null ? null : value; } var variable = prop.SetMethod; if (!r.IsNull(displayName)) { variable.Invoke(criticalCare, new object[] { v }); } } } criticalCares.Add(criticalCare); } } query = "select count(*) from critical_care_master cc, city_master cm where cc.city_id = cm.city_id and cc.is_active='y' " + where; var totalCount = new DataAccessManager().ExecuteScalar(query); var count = totalCount != null?int.Parse(totalCount.ToString()) : 0; var result = new PagedList <CriticalCareModel>() { TotalCount = count, Data = criticalCares }; return(result); }
public List <CriticalCareModel> GetAllCriticalCares() { var critical_cares = new List <CriticalCareModel>(); var query = "select * from critical_care_master where is_active='y' order by created_on desc"; var rows = new DataAccessManager().ExecuteSelectQuery(query); if (rows != null && rows.Count > 0) { foreach (DataRow r in rows) { var critical_care = new CriticalCareModel(); var props = typeof(CriticalCareModel).GetProperties(); foreach (var prop in props) { var ignore = Attribute.IsDefined(prop, typeof(IgnoreInsert)); if (!ignore) { var attribute = prop.GetCustomAttributes(typeof(DisplayNameAttribute), true).Cast <DisplayNameAttribute>().Single(); string displayName = attribute.DisplayName; var value = r[displayName]; var pType = prop.PropertyType; object v = null; if (pType == typeof(bool)) { v = value.ToString() == "y"; } else { v = value == null ? null : value; } var variable = prop.SetMethod; if (!r.IsNull(displayName)) { variable.Invoke(critical_care, new object[] { v }); } } } critical_cares.Add(critical_care); } } return(critical_cares); }
protected void SubmitCriticalCare(object sender, EventArgs e) { try { var criticalCare = new CriticalCareModel(); criticalCare.Specialities = speciality.Value; criticalCare.City = int.Parse(city.Value); criticalCare.Address = address.Value; criticalCare.Email = email.Value; criticalCare.IsActive = true; criticalCare.Mobile = mobile.Value; criticalCare.Name = name.Value; criticalCare.Created = DateTime.UtcNow.AddHours(5).AddMinutes(30); if (Request.Files.Count > 0) { var files = new List <string>(); for (var i = 0; i < Request.Files.Count; i++) { HttpPostedFile f = Request.Files[i]; if (f.ContentLength > 0) { var extension = Path.GetExtension(f.FileName); var fileName = Guid.NewGuid().ToString() + "." + extension; files.Add(fileName); string pathToSave_100 = HttpContext.Current.Server.MapPath("~/photo/" + fileName); f.SaveAs(pathToSave_100); } } if (files.Count > 0) { criticalCare.Images = string.Join(" ", files); } } var servicesKeys = Request.Form.AllKeys.Where(x => x.Contains("service")).ToList(); var services = new List <string>(); foreach (var key in servicesKeys) { var i = key.Replace("service", ""); services.Add(Request.Form["service" + i]); } criticalCare.Services = string.Join("\n", services); var sqlQuery = new Helper().GetInsertQuery <CriticalCareModel>(criticalCare); if (!string.IsNullOrWhiteSpace(cc_id.Value)) { criticalCare.Id = int.Parse(cc_id.Value); sqlQuery = new Helper().GetUpdateQuery <CriticalCareModel>(criticalCare); } var dam = new DataAccessManager().ExecuteInsertUpdateQuery(sqlQuery); if (dam) { Response.Redirect("CriticalCare", true); } } catch (Exception ex) { action.Value = "Failed To Add Doctor!"; } }