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(); } }