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();
}
}
public void Load(Context context)
{
if (ranges != null)
{
throw new Exception("Ranges already loaded.");
}
GmCommand cmd = context.Conn.CreateCommandById("selectCountFromGisRangesWhereTypeId");
cmd.AddInt("TypeId", id);
int count = (int)cmd.ExecuteScalar();
ranges = new List <GRange>(count);
if (count > 0)
{
cmd = context.Conn.CreateCommandById("selectAllFromGisRangesWhereTypeId");
cmd.AddInt("TypeId", id);
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
GRange range = new GRange(context, this, dr);
}
}
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name, MaxLength.BannerTopics.Name);
cmd.AddInt("B1", b1);
cmd.AddInt("B2", b2);
cmd.AddInt("B3", b3);
cmd.AddInt("B4", b4);
cmd.AddInt("B5", b5);
cmd.AddInt("B6", b6);
cmd.AddInt("B7", b7);
cmd.AddInt("B8", b8);
cmd.AddInt("B9", b9);
if (id == 0)
{
cmd.CommandText = "insert into BannerTopics values (@Name,@B1,@B2,@B3,@B4,@B5,@B6,@B7,@B8,@B9) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update BannerTopics set Name=@Name,B1=@B1,B2=@B2,B3=@B3,B4=@B4,B5=@B5,B6=@B6,B7=@B7,B8=@B8,B9=@B9 where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Load(Context context)
{
if (objects != null)
{
return;
}
lock (this)
{
if (objects != null)
{
return;
}
GmCommand cmd = context.Conn.CreateCommandById("selectCountFromGisObjectsWhereRangeId");
cmd.AddInt("RangeId", id);
int count = (int)cmd.ExecuteScalar();
objects = new List <GObject>(count);
if (count > 0)
{
cmd = context.Conn.CreateCommandById("selectAllFromGisObjectsWhereRangeId");
cmd.AddInt("RangeId", id);
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
GObject.Create(context, this, dr, true);
}
}
}
}
}
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();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PassportId", passportId);
cmd.AddInt("InsuranceId", insuranceId);
cmd.AddInt("PatientIdentificationId", patientIdentificationId);
cmd.AddInt("DoctorId", doctorId);
cmd.AddInt("DiagnosisId", diagnosisId);
cmd.AddString("PatientData", patientData.GetXmlString());
cmd.AddString("PatientDescription", patientDescription.GetXmlString());
cmd.AddDateTime("AdmissionDate", admissionDate);
cmd.AddInt("WardId", wardId);
cmd.AddInt("PatientTypeId", (int)patientTypeId);
cmd.AddString("PatientDiagnoses", patientDiagnoses.GetXmlString());
cmd.AddString("DietNumber", dietNumber);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into Patients values (@PassportId,@InsuranceId,@PatientIdentificationId,@DoctorId,@DiagnosisId,@PatientData,@PatientDescription,@AdmissionDate,@WardId,@PatientTypeId,0,null,null,@PatientDiagnoses,@DietNumber, @Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = @"update Patients set PassportId=@PassportId,InsuranceId=@InsuranceId,PatientIdentificationId=@PatientIdentificationId,DoctorId=@DoctorId,DiagnosisId=@DiagnosisId,PatientData=@PatientData,PatientDescription=@PatientDescription,AdmissionDate=@AdmissionDate,WardId=@WardId,PatientTypeId=@PatientTypeId,PatientDiagnoses=@PatientDiagnoses,DietNumber=@DietNumber, Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("ParentId", (int)parentId);
cmd.AddDateTime("Date", date);
cmd.AddString("Person", person);
cmd.AddString("Title", title);
cmd.AddString("Preview", preview);
cmd.AddString("Header", header);
cmd.AddString("Text", text);
cmd.AddString("Company", company);
cmd.AddInt("CityId", cityId);
cmd.AddString("Address", address);
cmd.AddString("Phone", phone);
cmd.AddString("Link", link);
cmd.AddString("Email", email);
cmd.AddInt("Status", (int)status);
cmd.AddString("Tag", tag);
cmd.AddBoolean("IsGroup", isGroup);
if (id == 0)
{
cmd.CommandText = "insert into Articles values (@ParentId,@Date,@Person,@Title,@Preview,@Header,@Text,@Company,@CityId,@Address,@Phone,@Link,@Email, @Status,@Tag,@IsGroup) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Articles set ParentId=@ParentId,Date=@Date,Person=@Person,Title=@Title,Preview=@Preview,Header=@Header,Text=@Text,Company=@Company,CityId=@CityId,Address=@Address,Phone=@Phone,Link=@Link,Email=@Email,Status=@Status, Tag=@Tag, IsGroup=@IsGroup where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public string GetParentTag(GmConnection conn)
{
if (parentId > 0)
{
GmCommand cmd = conn.CreateCommand("select Tag from Articles where Id=@Id");
cmd.AddInt("Id", parentId);
return(cmd.ExecuteScalar() as string);
}
return(null);
}
public int SaveWardHistory(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("PatientId", id);
cmd.AddDateTime("Date", DateTime.Now);
cmd.AddInt("WardId", wardId);
cmd.AddInt("PatientTypeId", (int)patientTypeId);
cmd.CommandText = "insert into PatientWardHistory values (@PatientId,@Date,@WardId,@PatientTypeId) select @@Identity";
return((int)(decimal)cmd.ExecuteScalar());
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name);
cmd.AddString("ShortName", shortName);
if (id == 0)
{
cmd.CommandText = "insert into PrescriptionTypes values (@Name,@ShortName) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update PrescriptionTypes set Name=@Name,ShortName=@ShortName where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into Medicaments values (@Name,@Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Medicaments set Name=@Name,Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name);
cmd.AddBinary("Permissions", permissions.GetBytes());
cmd.AddInt("WatchingGroupId", watchingGroupId);
if (id == 0)
{
cmd.CommandText = "insert into Roles values (@Name,@Permissions,@WatchingGroupId) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Roles set Name=@Name, Permissions=@Permissions, WatchingGroupId=@WatchingGroupId where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddDateTime("Date", date);
cmd.AddString("Question", question);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into Polls values (@Date,@Question,@Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Polls set Date=@Date,Question=@Question,Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PassportId", passportId);
cmd.AddString("Login", login);
cmd.AddString("Password", password);
if (id == 0)
{
cmd.CommandText = "insert into Employees values (@Id,@PassportId,@Login,@Password) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Employees set PassportId=@PassportId,Login=@Login,@Password=@Password where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name);
cmd.AddString("Code", code);
cmd.AddString("HandbookGroupId", handbookGroupId);
if (id == 0)
{
cmd.CommandText = "insert into AnalysisTypes values (@Name,@Code,@HandbookGroupId) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update AnalysisTypes set Name=@Name,Code=@Code,HandbookGroupId=@HandbookGroupId where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void SaveDischargeData(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("DischargeTypeId", (int)dischargeTypeId);
cmd.AddString("DischargeData", dischargeData.GetXmlString());
cmd.AddNullableDateTime("DischargeDate", dischargeDate);
if (id == 0)
{
cmd.CommandText = "insert into Patients values (DischargeTypeId,@DischargeData,@DischargeDate) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = @"update Patients set DischargeTypeId=@DischargeTypeId,DischargeData=@DischargeData,DischargeDate=@DischargeDate where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Number", number);
cmd.AddInt("WardTypeId", (int)wardTypeId);
cmd.AddInt("NumberOfBeds", numberOfBeds);
if (id == 0)
{
cmd.CommandText = "insert into Wards values (@Number,@WardTypeId,@NumberOfBeds) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Wards set Number=@Number,WardTypeId=@WardTypeId,NumberOfBeds=@NumberOfBeds where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PatientId", patientId);
cmd.AddDateTime("Date", date);
cmd.AddString("ReacardData", reacardData.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into Reacards values (@PatientId,@Date,@ReacardData) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Reacards set PatientId=@PatientId,Date=@Date,ReacardData=@ReacardData where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("ArticleId", articleId);
cmd.AddString("Key", key);
cmd.AddString("Value", value);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into ArticleParams values (@ArticleId,@Key,@Value,@Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update ArticleParams set [Key]=@Key,Value=@Value,Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("InsuranceCompanyId", insuranceCompanyId);
cmd.AddString("Number", number);
cmd.AddString("Series", series);
cmd.AddString("Delo", delo);
if (id == 0)
{
cmd.CommandText = "insert into Insurances values (@InsuranceCompanyId,@Number,@Series,@Delo) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Insurances set InsuranceCompanyId=@InsuranceCompanyId,Number=@Number,Series=@Series,Delo=@Delo where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("UserId", userId);
cmd.AddString("Name", name);
cmd.AddString("Data", data.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into WatchingSchemes values (@UserId,@Name,@Data) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update WatchingSchemes set UserId=@UserId,Name=@Name,Data=@Data where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PollId", pollId);
cmd.AddString("Answer", answer);
cmd.AddInt("Count", count);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into PollAnswers values (@PollId,@Answer,@Count,@Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update PollAnswers set PollId=@PollId,Answer=@Answer,Count=@Count,Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PatientId", patientId);
cmd.AddDateTime("RequestDate", requestDate);
cmd.AddNullableDateTime("ExecutionDate", executionDate);
cmd.AddString("ConsultationData", consultationData.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into PatientConsultations values (@PatientId,@RequestDate,@ExecutionDate,@ConsultationData) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update PatientConsultations set PatientId=@PatientId,RequestDate=@RequestDate,ExecutionDate=@ExecutionDate,ConsultationData=@ConsultationData where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name, MaxLength.Pages.Name);
cmd.AddInt("BannerTopicId", bannerTopicId);
cmd.AddString("Title", title, MaxLength.Pages.Title);
cmd.AddString("Description", description, MaxLength.Pages.Description);
cmd.AddString("Keywords", keywords, MaxLength.Pages.Keywords);
if (id == 0)
{
cmd.CommandText = "insert into Pages values (@Name,@BannerTopicId,@Title,@Description,@Keywords) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Pages set Name=@Name,BannerTopicId=@BannerTopicId,Title=@Title,Description=@Description,Keywords=@Keywords where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("ForumId", forumId);
cmd.AddDateTime("Date", date);
cmd.AddString("Name", name, MaxLength.ForumTopics.Name);
cmd.AddString("Description", description, MaxLength.ForumTopics.Description);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into ForumTopics values (@ForumId,@Date,@Name,@Description,@Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update ForumTopics set ForumId=@ForumId,Name=@Name,Description=@Description,Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("CommunityId", communityId);
cmd.AddString("Name", name, MaxLength.Galleries.Name);
cmd.AddString("Text", text, MaxLength.Galleries.Text);
cmd.AddInt("Status", (int)status);
cmd.AddString("Logo", logo, MaxLength.Galleries.Logo);
if (id == 0)
{
cmd.CommandText = "insert into Galleries values (@CommunityId,@Name,@Text,@Status,@Logo) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Galleries set CommunityId=@CommunityId,Name=@Name,Text=@Text,Status=@Status,Logo=@Logo where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("UserId", userId);
cmd.AddDateTime("StartTime", startTime);
cmd.AddNullableDateTime("EndTime", endTime);
cmd.AddString("Data", data.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into Watching values (@UserId,@StartTime,@EndTime,@Data) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Watching set UserId=@UserId,StartTime=@StartTime,EndTime=@EndTime,Data=@Data where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("GalleryId", galleryId);
cmd.AddString("Filename", filename);
cmd.AddString("Name", name);
cmd.AddString("Text", text);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into GalleryImages values (@GalleryId,@Filename,@Name,@Text,@Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update GalleryImages set GalleryId=@GalleryId,Filename=@Filename,Name=@Name,Text=@Text,Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Surname", surname);
cmd.AddString("Name", name);
cmd.AddString("MiddleName", middleName);
cmd.AddInt("Gender", (int)gender);
cmd.AddNullableDateTime("Birthday", birthday);
cmd.AddString("IdentificationData", identificationData.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into PatientIdentifications values (@Surname,@Name,@MiddleName,@Gender,@Birthday,@IdentificationData) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update PatientIdentifications set Surname=@Surname,Name=@Name,MiddleName=@MiddleName,Gender=@Gender,Birthday=@Birthday,IdentificationData=@IdentificationData where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PatientId", patientId);
cmd.AddInt("DoctorId", doctorId);
cmd.AddDateTime("Time", time);
cmd.AddString("Description", description.GetXmlString());
cmd.AddInt("ObservationTypeId", (int)observationTypeId);
if (id == 0)
{
cmd.CommandText = "insert into Observations values (@PatientId,@DoctorId,@Time,@Description,@ObservationTypeId) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Observations set PatientId=@PatientId,DoctorId=@DoctorId,Time=@Time,Description=@Description,ObservationTypeId=@ObservationTypeId where Id=@Id";
cmd.ExecuteNonQuery();
}
}
