private void BindPatientSearch(bool isBind) { DataTable dtRemainderSMS = new AdministrationBAL().GetRemainderSMS(); foreach (DataRow dr in dtRemainderSMS.Rows) { dr["Sent On"] = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(Convert.ToDateTime(dr["Sent On"]), "India Standard Time"); } dtRemainderSMS.AcceptChanges(); rgRemainderSMS.DataSource = dtRemainderSMS; if (!isBind) { rgRemainderSMS.DataBind(); } }
private void BindIndividualSMSSearch(bool isBind) { DataTable dtIndividualSMS = new AdministrationBAL().GetSMSIndividual(); foreach (DataRow dr in dtIndividualSMS.Rows) { dr["CreatedOn"] = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(Convert.ToDateTime(dr["CreatedOn"]), "India Standard Time"); } dtIndividualSMS.AcceptChanges(); rgSMSIndividual.DataSource = dtIndividualSMS; if (!isBind) { rgSMSIndividual.DataBind(); } }
protected void rgAdminHospitalList_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e) { GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem; string mobileId = dataItem.GetDataKeyValue("Mobile").ToString(); DataTable dtDepartment = new AdministrationBAL().GetExistingHospital(mobileId); dtDepartment.Columns.Add("Address", typeof(string)); foreach (DataRow dr in dtDepartment.Rows) { if (!string.IsNullOrEmpty(dr["AddressLine"].ToString())) { dr["Address"] += dr["AddressLine"].ToString(); } if (!string.IsNullOrEmpty(dr["CityName"].ToString())) { dr["Address"] += ", " + dr["CityName"].ToString(); } if (!string.IsNullOrEmpty(dr["StateName"].ToString())) { dr["Address"] += ", " + dr["StateName"].ToString(); } if (!string.IsNullOrEmpty(dr["CountryName"].ToString())) { dr["Address"] += ", " + dr["CountryName"].ToString(); } if (!string.IsNullOrEmpty(dr["PostalCode"].ToString())) { dr["Address"] += ", " + dr["PostalCode"].ToString(); } } dtDepartment.AcceptChanges(); e.DetailTableView.DataSource = dtDepartment; //if (!IsRebind) // rgAdminHospitalList.DataBind(); }
private void BindHospital(bool IsRebind) { DataTable dtDepartment = new AdministrationBAL().GetHospital(); dtDepartment.Columns.Add("Address", typeof(string)); foreach (DataRow dr in dtDepartment.Rows) { if (!string.IsNullOrEmpty(dr["AddressLine"].ToString())) { dr["Address"] += dr["AddressLine"].ToString(); } if (!string.IsNullOrEmpty(dr["CityName"].ToString())) { dr["Address"] += ", " + dr["CityName"].ToString(); } if (!string.IsNullOrEmpty(dr["StateName"].ToString())) { dr["Address"] += ", " + dr["StateName"].ToString(); } if (!string.IsNullOrEmpty(dr["CountryName"].ToString())) { dr["Address"] += ", " + dr["CountryName"].ToString(); } if (!string.IsNullOrEmpty(dr["PostalCode"].ToString())) { dr["Address"] += ", " + dr["PostalCode"].ToString(); } } dtDepartment.AcceptChanges(); rgAdminHospitalList.DataSource = dtDepartment; if (!IsRebind) { rgAdminHospitalList.DataBind(); } }
private void BindHospital() { DataTable dtHospital = new AdministrationBAL().GetHospitalList(); foreach (DataRow dr in dtHospital.Rows) { dr["OrganizationName"] += " ("; dr["OrganizationName"] += dr["CountryName"].ToString(); dr["OrganizationName"] += (!string.IsNullOrEmpty(dr["StateName"].ToString())) ? ", " + dr["StateName"].ToString() : string.Empty; dr["OrganizationName"] += (!string.IsNullOrEmpty(dr["CityName"].ToString())) ? ", " + dr["CityName"].ToString() : string.Empty; dr["OrganizationName"] += ")"; } dtHospital.AcceptChanges(); ddlHospitalView.DataSource = dtHospital; ddlHospitalView.DataTextField = "OrganizationName"; ddlHospitalView.DataValueField = "OrganizationId"; ddlHospitalView.DataBind(); //ddlHospitalView.Items.Insert(0, new ListItem("-------------------------------------Select Hospital-----------------------------------------------", "0")); //ddlHospitalView.SelectedIndex = 0; }
private void BindAppointment(bool isBind) { DataTable dtAppointmentView = new AdministrationBAL().GetAppointmentview(); foreach (DataRow drAppointmentView in dtAppointmentView.Rows) { if (!string.IsNullOrEmpty(drAppointmentView["ScheduleAddress"].ToString())) { drAppointmentView["ScheduleAddress"] = drAppointmentView["ScheduleAddress"].ToString().Replace("\r\n\r\n", "\n").Replace("\r\n", "\n").Replace("\n\n", "\n").Replace("\n", ", \n"); } else { StringBuilder ScheduleAddress = new StringBuilder(); ScheduleAddress.AppendLine(drAppointmentView["OrganizationName"].ToString()); ScheduleAddress.AppendLine((!string.IsNullOrEmpty(drAppointmentView["AddressLine2"].ToString())) ? " \n" + drAppointmentView["AddressLine1"].ToString() + " \n" + drAppointmentView["AddressLine2"].ToString() : " \n" + drAppointmentView["AddressLine1"].ToString()); ScheduleAddress.AppendLine((!string.IsNullOrEmpty(drAppointmentView["CityName"].ToString())) ? " \n" + drAppointmentView["CityName"].ToString() : string.Empty); ScheduleAddress.AppendLine((!string.IsNullOrEmpty(drAppointmentView["StateName"].ToString())) ? " \n" + drAppointmentView["StateName"].ToString() : string.Empty); ScheduleAddress.AppendLine((!string.IsNullOrEmpty(drAppointmentView["CountryName"].ToString())) ? " \n" + drAppointmentView["CountryName"].ToString() : string.Empty); ScheduleAddress.AppendLine((!string.IsNullOrEmpty(drAppointmentView["PostalCode"].ToString())) ? " \nPostalCode:" + drAppointmentView["PostalCode"].ToString() : string.Empty); ScheduleAddress.AppendLine((!string.IsNullOrEmpty(drAppointmentView["Phone"].ToString())) ? " \nPhone: " + drAppointmentView["Phone"].ToString() : string.Empty); drAppointmentView["ScheduleAddress"] = ScheduleAddress.ToString(); } drAppointmentView["CreatedOn"] = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(Convert.ToDateTime(drAppointmentView["CreatedOn"]), "India Standard Time"); } dtAppointmentView.AcceptChanges(); rgAdminAppointmentView.DataSource = dtAppointmentView; if (!isBind) { rgAdminAppointmentView.DataBind(); } }