private PatientConsultation GetPatientConsultation()
{
using (GmConnection conn = App.CreateConnection())
{
return(PatientConsultation.GetPatientConsultation(conn, SelectedId));
}
}
public static int Remove(GmConnection conn, int id)
{
GmCommand cmd = conn.CreateCommand("delete from PatientIdentifications where Id=@Id");
cmd.AddInt("Id", id);
return(cmd.ExecuteNonQuery());
}
void LoadData()
{
using (GmConnection conn = App.ConnectionFactory.CreateConnection())
{
GmCommand cmd = conn.CreateCommand("select ProductCode, Name as ProductName, ParentProductCode from Product where DeletedFlag=0 and GroupFlag=1");
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Product p = new Product(dr);
htProducts.Add(p.Code, p);
}
}
}
foreach (Product p in htProducts.Values)
{
if (p.ParentCode != null)
{
Product parent = htProducts[p.ParentCode] as Product;
p.SetParent(parent);
}
else
{
rootProducts.Add(p);
}
}
treeView.BeginUpdate();
BuildTree(treeView.Nodes, rootProducts);
treeView.EndUpdate();
UpdateControls();
UpdateStatus();
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
try
{
ForumMessage forumMessage = new ForumMessage();
forumMessage.userId = userId;
forumMessage.forumTopicId = forumTopicId;
forumMessage.userName = tbName.Text.Trim();
forumMessage.text = tbText.Text.Trim();
using (GmConnection conn = Global.CreateConnection())
{
forumMessage.Save(conn);
}
Server.Transfer("ForumMessages.aspx?ft=" + forumTopicId);
// lblResult.Text = string.Format("Message добавлено.");
// WebUtils.Redirect(this, "Private/Users.aspx");
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ex)
{
log.Exception(ex);
}
}
public void Update(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
// cmd.AddInt("RecordId", recordId);
cmd.AddDateTime("Date", date);
cmd.AddString("Name", name, MaxLength.UserInfo.Name);
cmd.AddString("Email", email, MaxLength.UserInfo.Email);
cmd.CommandText = "update UserInfo set Date=@Date,Name=@Name,Email=@Email";
if (psw.Length > 0)
{
cmd.CommandText += ",Psw=@Psw";
cmd.AddString("Psw", psw, MaxLength.UserInfo.Psw);
}
if (picture.Length > 0)
{
cmd.CommandText += ",Picture=@Picture";
cmd.AddString("Picture", picture, MaxLength.UserInfo.Picture);
}
// cmd.AddInt("UserRole", (int)userRole);
// cmd.AddInt("Status", (int)status);
cmd.CommandText += " where Id=@Id";
cmd.ExecuteNonQuery();
}
public void LoadData()
{
int userId = Utils.GetUserId(Context);
if (userId == 0)
{
return;
}
UserInfo ui = null;
using (GmConnection conn = Global.CreateConnection())
{
ui = UserInfo.GetUserInfo(conn, userId);
}
if (ui == null)
{
return;
}
hfId.Value = ui.Id.ToString();
// tbDate.Text = Utils.ToString(userInfo.date);
tbName.Text = ui.name;
tbEmail.Text = ui.email;
// tbDate.MaxLength = MaxLength.Input.dateString;
tbName.MaxLength = MaxLength.UserInfo.Name;
tbEmail.MaxLength = MaxLength.UserInfo.Email;
tbPassword.MaxLength = MaxLength.UserInfo.Psw;
}
private void Open()
{
try
{
if (readOnly)
{
return;
}
DataRow dr = SelectedRow;
if (dr != null)
{
int id = (int)dr["Id"];
Medicament medicament = null;
using (GmConnection conn = App.CreateConnection())
{
medicament = Medicament.GetMedicament(conn, id);
}
if (medicament != null)
{
MedicamentForm form = new MedicamentForm(medicament);
if (form.ShowDialog() == DialogResult.OK)
{
dr["Name"] = medicament.name;
}
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
public static int Remove(GmConnection conn, int id)
{
GmCommand cmd = conn.CreateCommand("delete from LinkExchange where Id=@Id"); //!!!
cmd.AddInt("Id", id);
return(cmd.ExecuteNonQuery());
}
private void InitPager(int parentId, int topNumber, bool enablePager)
{
ucPager.top = "@TopNumber";
ucPager.fields = "Id, Date, Title, Preview, Header, Link, IsGroup";
ucPager.table = "Articles";
ucPager.cond = "(ParentId = @ParentId) and Articles.Status>=0";
ucPager.order = "Date desc";
if (enablePager)
{
int count = 0;
string cmdText = ucPager.GetCountQuery();
using (GmConnection conn = Global.CreateConnection())
{
GmCommand cmd = conn.CreateCommand(cmdText);
cmd.AddInt("ParentId", parentId);
cmd.AddInt("TopNumber", topNumber);
count = (int)conn.ExecuteScalar(cmd);
}
ucPager.GenerateControls(count);
this.SqlDataSource1.SelectCommand = ucPager.GetPageQuery();
}
else
{
ucPager.Visible = false;
this.SqlDataSource1.SelectCommand = ucPager.GetSelectQuery();
}
}
void LoadData()
{
int id = RequestUtils.GetArticleId(this);
if (id != 0)
{
using (GmConnection conn = Global.CreateConnection())
{
article = Article.GetArticle(conn, id);
}
}
if (article == null)
{
article = new Article();
int ag = RequestUtils.GetArticleGroupId(this);
if (ag != 0)
{
article.parentId = ag;
}
else
{
article.isGroup = true;
}
}
}
public static object ExecuteScalar(string cmdText)
{
using (GmConnection conn = Global.CreateConnection())
{
return(conn.ExecuteScalar(cmdText));
}
}
public static ReportsDataSet.PatientMedicamentsDataTable GetPatientMedicamentsTable(ConnectionFactory factory, int patientId)
{
ReportsDataSet.PatientMedicamentsDataTable dtPatientMedicaments = new ReportsDataSet.PatientMedicamentsDataTable();
string cmdText = @"
SELECT StoreProducts.Id, Products.Name, Products.PackedNumber, Products.Maker, Prescriptions.Dose * Prescriptions.Multiplicity * Prescriptions.Duration AS Count,
StoreProducts.Price, Prescriptions.Dose * Prescriptions.Multiplicity * Prescriptions.Duration * StoreProducts.Price AS Sum, Series, MedLists
FROM Prescriptions
LEFT OUTER JOIN StoreProducts ON StoreProducts.Id = Prescriptions.StoreProductId
LEFT OUTER JOIN Products ON Products.Id = StoreProducts.ProductId
WHERE Prescriptions.PatientId = @PatientId";
using (GmConnection conn = factory.CreateConnection())
{
GmCommand cmd = conn.CreateCommand(cmdText);
cmd.AddInt("PatientId", patientId);
conn.Fill(dtPatientMedicaments, cmd);
}
int index = 0;
foreach (ReportsDataSet.PatientMedicamentsRow row in dtPatientMedicaments.Rows)
{
row.Id = ++index;
}
return(dtPatientMedicaments);
}
public PatientMedicamentsReportBuilder(ConnectionFactory factory, Config config, Patient patient)
: base(ReportBuilderId.PatientMedicaments)
{
AddDataSource("ReportsDataSet_PatientMedicaments", GetPatientMedicamentsTable(factory, patient.Id));
Insurance insurance;
string insuranceCompanyName = "";
using (GmConnection conn = factory.CreateConnection())
{
AddParameter("PatientName", patient.GetPatientName(conn));
AddParameter("DoctorName", patient.GetDoctorName(conn));
AddParameter("ChiefName", patient.GetChiefName(conn));
AddParameter("Age", patient.GetAgeStr(conn));
insurance = patient.GetInsurance(conn);
if (insurance != null)
{
insuranceCompanyName = insurance.GetInsuranceCompanyName(conn);
}
}
AddParameter("HeadDoctor", config.departmentConfig.headDoctor);
AddParameter("DepartmentName", config.departmentConfig.departmentName);
AddParameter("HospitalName", config.departmentConfig.hospitalName);
DiagnosisInfo di = patient.patientDiagnoses.LatestDiagnosisInfo;
AddParameter("Diagnosis", di.text);
AddParameter("DiagnosisCode", di.code);
AddParameter("AdmissionDate", patient.admissionDate);
AddParameter("DischargeDate", patient.DischargeDateStr);
AddParameter("Duration", patient.Duration);
AddParameter("CaseHistoryNumber", patient.patientData);
AddParameter("InsuranceNumber", insurance != null?insurance.number:"");
AddParameter("InsuranceCompany", insuranceCompanyName);
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PositionId", positionId);
cmd.AddDateTime("Date", date);
cmd.AddString("Name", name);
cmd.AddString("Surname", surname);
cmd.AddString("Address", address);
cmd.AddString("Phone", phone);
cmd.AddString("Link", link);
cmd.AddString("Email", email);
cmd.AddString("Resume", resume);
cmd.AddString("Comments", comments);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into Candidates values (@PositionId,@Date,@Name,@Surname,@Address,@Phone,@Link,@Email,@Resume,@Comments,@Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
// cmd.CommandText = "update Competitors set PositionId=@PositionId,Date=@Date,Name=@Name,Surname=@Surname,Address=@Address,Phone=@Phone,Link=@Link,Email=@Email, Resume=@Resume, Comments=@Comments,Status=@Status where Id=@Id";
// cmd.ExecuteNonQuery();
}
}
void LoadData()
{
int id = RequestUtils.GetGalleryImageId(this);
if (id != 0)
{
using (GmConnection conn = Global.CreateConnection())
{
galleryImage = GalleryImage.GetGalleryImage(conn, id);
}
}
if (galleryImage == null)
{
galleryImage = new GalleryImage();
int gl = RequestUtils.GetGalleryId(this);
if (gl != 0)
{
galleryImage.galleryId = gl;
}
}
using (GmConnection conn = Global.CreateConnection())
{
Utils.FillDDL(conn, ddlStatus, "select Id, Name from Statuses", (int)galleryImage.status);
}
tbFilename.Text = galleryImage.filename;
tbName.Text = galleryImage.name;
tbText.Text = galleryImage.text;
tbName.MaxLength = MaxLength.GalleryImages.Name;
tbFilename.MaxLength = MaxLength.GalleryImages.Filename;
tbText.MaxLength = MaxLength.GalleryImages.Text;
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("SerialNumber", serialNumber);
cmd.AddString("IssueDepartment", issueDepartment);
cmd.AddDateTime("IssueDate", issueDate);
cmd.AddString("DepartmentCode", departmentCode);
cmd.AddString("Surname", surname);
cmd.AddString("Name", name);
cmd.AddString("MiddleName", middleName);
cmd.AddInt("Gender", (int)gender);
cmd.AddDateTime("Birthday", birthday);
cmd.AddString("BirthPlace", birthPlace);
cmd.AddString("Registration", registration);
if (id == 0)
{
cmd.CommandText = "insert into Passports values (@SerialNumber,@IssueDepartment,@IssueDate,@DepartmentCode,@Surname,@Name,@MiddleName,@Gender,@Birthday,@BirthPlace,@Registration) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Passports set SerialNumber=@SerialNumber,IssueDepartment=@IssueDepartment,IssueDate=@IssueDate,DepartmentCode=@DepartmentCode,Surname=@Surname,Name=@Name,MiddleName=@MiddleName,Gender=@Gender,Birthday=@Birthday,BirthPlace=@BirthPlace,Registration=@Registration where Id=@Id";
cmd.ExecuteNonQuery();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
lblInfo.Text = "";
lblResult.Text = "";
if (fileUpload.FileName.Trim().Length > 0)
{
Upload();
}
if (tbFilename.Text.Length > 0)
{
galleryImage.name = tbName.Text.Trim();
galleryImage.filename = tbFilename.Text.Trim();
galleryImage.text = tbText.Text.Trim();
galleryImage.status = (RecordStatus)int.Parse(ddlStatus.SelectedValue);
using (GmConnection conn = Global.CreateConnection())
{
galleryImage.Save(conn);
}
lblResult.Text = string.Format("Data saved.");
}
// WebUtils.Redirect(this, "Private/Users.aspx");
}
catch (Exception ex)
{
log.Exception(ex);
}
}
private void CheckDuration(GmConnection conn, List <Patient> patients)
{
string cmdText = @"SELECT PatientWardHistory.PatientId, MAX(PatientWardHistory.Date) AS PatientWardHistoryDate
FROM PatientWardHistory
LEFT OUTER JOIN Patients ON Patients.Id = PatientWardHistory.PatientId AND Patients.PatientTypeId = PatientWardHistory.PatientTypeId";
cmdText += string.Format(" where (PatientWardHistory.PatientTypeId={0} or PatientWardHistory.PatientTypeId={1}) and PatientWardHistory.PatientId in ({2})", (int)PatientTypeId.IntensiveCare, (int)PatientTypeId.Reanimation, GetCommaSeparatedList(patients));
cmdText += " GROUP BY PatientWardHistory.PatientId";
Dictionary <int, DateTime> transferDates = new Dictionary <int, DateTime>();
using (DbDataReader dr = conn.ExecuteReader(cmdText)) while (dr.Read())
{
transferDates.Add(dr.GetInt32(0), dr.GetDateTime(1));
}
List <Patient> commonPatients = new List <Patient>();
List <Patient> intensiveCarePatients = new List <Patient>();
List <Patient> reanimationPatients = new List <Patient>();
foreach (Patient patient in patients)
{
DateTime whenArrived = transferDates.ContainsKey(patient.Id) ? transferDates[patient.Id] : patient.admissionDate;
TimeSpan ts = DateTime.Now - whenArrived;
switch (patient.patientTypeId)
{
case PatientTypeId.Reanimation:
if (ts.TotalDays >= depConfig.reanimationMaxDuration)
{
reanimationPatients.Add(patient);
}
break;
case PatientTypeId.IntensiveCare:
if (ts.TotalDays >= depConfig.intensiveCareMaxDuration)
{
intensiveCarePatients.Add(patient);
}
break;
case PatientTypeId.Common:
DiagnosisInfo di = patient.LatestDiagnosisInfo;
if (di != null)
{
Diagnosis d = appCache.GetDiagnosis(di.id);
if (d != null)
{
int hospitalStay = depConfig.GetRecommendedHospitalStay(d);
if (ts.TotalDays >= hospitalStay)
{
commonPatients.Add(patient);
}
}
}
break;
}
}
AddTask(TaskTypeId.CommonDuration, commonPatients);
AddTask(TaskTypeId.IntensiveCareDuration, intensiveCarePatients);
AddTask(TaskTypeId.ReanimationDuration, reanimationPatients);
}
public bool IsMultyLoginDenied()
{
bool denied = false;
if (UserId != 0)
{
using (GmConnection conn = App.ConnectionFactory.CreateConnection())
{
GmCommand cmd = conn.CreateCommand("select MultiLoginFlag, lastupdate, GETDATE() from [User] where UserCode=@UserCode");
cmd.AddInt("UserCode", UserId);
using (IDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
int i = 0;
bool multiLoginFlag = dr.GetBoolean(i++);
if (multiLoginFlag)
{
DateTime lastUpdate = dr.GetDateTime(i++);
DateTime curTime = dr.GetDateTime(i++);
TimeSpan ts = curTime - lastUpdate;
denied = ts.TotalMilliseconds < this.config.PollTime * 2; //+config.CommandTimeout*1000
}
}
}
}
}
return(denied);
}
private void btnRemove_Click(object sender, EventArgs e)
{
try
{
int patientId = SelectedId;
DataRow dr = SelectedRow;
if (patientId != 0 && dr != null)
{
int doctorId = (int)dr["DoctorId"];
if (doctorId == App.Instance.UserInfo.UserId)
// if (App.Instance.UserInfo.HasWatching && App.Instance.UserInfo.Watching.HasPatient(patientId))
{
if (MessageBoxUtils.Ask("¬ы уверены, что хотите удалить пациента " + patientId))
{
using (WaitCursor wc = new WaitCursor())
{
using (GmConnection conn = App.CreateConnection())
{
Patient.SetStatus(conn, patientId, Status.Removed);
}
dr.Delete();
}
}
}
else
{
MessageBox.Show("¬ы можете удал¤ть только своих пациентов.");
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
log = new Log(this);
try
{
forumTopicId = RequestUtils.GetForumTopicId(this);
userId = Utils.GetUserId(Context);
if (!base.IsPostBack)
{
if (userId != 0)
{
using (GmConnection conn = Global.CreateConnection())
{
string s = conn.ExecuteScalar("select Name from UserInfo where Id=" + userId) as string;
if (s != null)
{
tbName.Text = s;
}
}
}
}
}
catch (Exception ex)
{
log.Exception(ex);
}
}
private void LoadPatients()
{
dataTable.Clear();
string cmdText = @"
select Patients.Id, Passports.Surname, Passports.Name, Passports.MiddleName, AdmissionDate, DischargeDate, Wards.Number as WardNumber, Patients.DoctorId, Users.Name as DoctorName
from Patients
left join Passports on PassportId=Passports.Id
left join Wards on WardId=Wards.Id
left join Users on DoctorId=Users.Id
where Patients.Status=1";
if (App.Instance.UserInfo.HasWatching && !App.Instance.UserInfo.Watching.IsEmpty)
{
cmdText += string.Format("and Patients.Id in ({0})", App.Instance.UserInfo.Watching.GetCommaSeparatedPatientList());
}
if (chkDischarged.Checked)
{
cmdText += " and DischargeDate is not null";
}
else
{
cmdText += " and DischargeDate is null";
}
using (GmConnection conn = App.CreateConnection())
{
dataAdapter = conn.CreateDataAdapter(cmdText);
dataAdapter.Fill(dataTable);
}
dataTable.DefaultView.Sort = "WardNumber";
gridView.DataSource = dataTable;
}
public static ReportsDataSet.PrescriptionsDataTable GetPrescriptionsTable(ConnectionFactory factory, int patientId)
{
DataTable dataTable = new DataTable();
string cmdText = @"
select Prescriptions.*, Products.Name as ProductName, BaseUnits.Name as BaseUnitName
from Prescriptions
left join StoreProducts on StoreProducts.Id=StoreProductId
left join Products on Products.Id=ProductId
left join BaseUnits on BaseUnits.Id=BaseUnitId
where PatientId=" + patientId;
using (GmConnection conn = factory.CreateConnection())
{
conn.Fill(dataTable, cmdText);
}
ReportsDataSet.PrescriptionsDataTable dtPrescriptions = new ReportsDataSet.PrescriptionsDataTable();
int[] rowIndexes = { 0, 0, 0, 0 };
foreach (DataRow dr in dataTable.Rows)
{
int pt = GetColumnIndex((PrescriptionTypeId)dr["PrescriptionTypeId"]);
if (pt < 1 || pt > 3)
{
continue;
}
int startCol = (pt - 1) * 3;
int rowIndex = rowIndexes[pt];
rowIndexes[pt]++;
ReportsDataSet.PrescriptionsRow row = GetRow(dtPrescriptions, rowIndex);
row[startCol] = string.Format("{0:dd.MM}", dr["StartDate"]);
row[startCol + 1] = string.Format("{0:dd.MM}", dr["EndDate"]);
row[startCol + 2] = string.Format("{0} {1}{2}x{3}ð", dr["ProductName"], dr["Dose"], dr["BaseUnitName"], dr["Multiplicity"]);
}
AppendAnalyses(factory, patientId, dtPrescriptions, rowIndexes[rowIndexes.Length - 1]);
return(dtPrescriptions);
}
private void btnRemove_Click(object sender, EventArgs e)
{
try
{
DataRow selRow = SelectedRow;
if (selRow != null)
{
bool completed = (bool)selRow["Completed"];
if (completed)
{
FormUtils.Message("”комплектованный документ не может быть удален.");
return;
}
int id = (int)selRow[0];
using (GmConnection conn = App.CreateConnection())
{
Document.Remove(conn, id);
Document.RemoveDocumentProducts(conn, id);
}
dataTable.Rows.Remove(selRow);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
public static DbDataAdapter CreateDataAdapter(GmConnection conn, Document doc)
{
DbDataAdapter da = conn.CreateDataAdapter();
GmCommand cmd = conn.CreateCommand(selectCmdText);
cmd.AddInt("DocumentId", doc.DocumentId);
cmd.AddBool("FactFlag", false);
(da as IDbDataAdapter).SelectCommand = cmd.DbCommand;
cmd = conn.CreateCommand(insertCmdText);
cmd.AddString("ProductCode").SourceColumn = "ProductCode";
cmd.AddString("UnitCode").SourceColumn = "UnitCode";
cmd.AddInt("DocumentId", doc.DocumentId);
cmd.AddDecimal("Coef").SourceColumn = "Coef";
cmd.AddDecimal("Count").SourceColumn = "Count";
cmd.AddBool("FactFlag", true);
cmd.AddBool("HandledFlag").SourceColumn = "HandledFlag";
cmd.DbCommand.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord;
(da as IDbDataAdapter).InsertCommand = cmd.DbCommand;
cmd = conn.CreateCommand(deleteCmdText);
cmd.AddInt("DocumentProductId").SourceColumn = "DocumentProductId";
(da as IDbDataAdapter).DeleteCommand = cmd.DbCommand;
cmd = conn.CreateCommand(updateCmdText);
cmd.AddInt("DocumentProductId").SourceColumn = "DocumentProductId";
cmd.AddDecimal("Count").SourceColumn = "Count";
cmd.AddBool("HandledFlag").SourceColumn = "HandledFlag";
(da as IDbDataAdapter).UpdateCommand = cmd.DbCommand;
return(da);
}
private void Open()
{
try
{
int id = SelectedId;
if (id != 0)
{
Document doc = null;
using (GmConnection conn = App.CreateConnection())
{
doc = Document.GetDocument(conn, id);
}
if (doc != null)
{
if (OpenDocument(doc))
{
// UpdateRow(SelectedRow,doc);
}
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
private void Open()
{
try
{
using (WaitCursor wc = new WaitCursor())
{
int id = SelectedId;
if (id != 0)
{
Observation observation = null;
using (GmConnection conn = App.CreateConnection())
{
observation = Observation.GetObservation(conn, id);
}
if (observation != null)
{
// string observationTypeName = (string)SelectedRow["ObservationTypeName"];
ObservationForm form = new ObservationForm(observation, patientName);
if (form.ShowDialog() == DialogResult.OK)
{
UpdateRow(SelectedRow, observation);
}
}
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Log log = MainMasterPage.InitPage(this);
int id = RequestUtils.GetGalleryImageId(this);
this.SqlDataSource1.SelectParameters["GalleryImageId"].DefaultValue = id.ToString();
try
{
if (id != 0)
{
string name = null;
using (GmConnection conn = Global.CreateConnection())
{
name = conn.ExecuteScalar("select Name from GalleryImages where Id=" + id) as string;
}
if (name != null)
{
(this.Master as MainMasterPage).PageInfo.AddInfo(name);
}
}
}
catch (Exception ex)
{
log.Exception(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Poll poll = null;
try
{
log = new Log(this);
if (!IsPostBack)
{
using (GmConnection conn = Global.CreateConnection())
{
poll = Poll.GetLastPoll(conn);
}
if (poll != null)
{
lblQuestion.Text = poll.question;
SqlDataSource1.SelectParameters["PollId"].DefaultValue = poll.Id.ToString();
}
}
}
catch (Exception ex)
{
if (log != null)
{
log.Exception(ex);
}
}
finally
{
if (poll == null)
{
this.Visible = false;
}
}
}
public static DataTable Fill(ComboBox cb, GmConnection conn, string cmdText, int selectedValue, string zeroText)
{
DataTable dt = Fill(cb, conn, cmdText, zeroText);
cb.SelectedValue = selectedValue;
return(dt);
}