public bool UpdateSupervisorData() { IdentityImage = BaseDataBase.CheckImageFile(IdentityImage, Supervisor.GetSupervisorByID(SupervisorID).IdentityImage); return(BaseDataBase._StoredProcedure("sp_UpdateSupervisor" , new SqlParameter("@SupervisorID", SupervisorID) , new SqlParameter("@FirstName", FirstName) , new SqlParameter("@LastName", LastName) , new SqlParameter("@BirthPlace", BirthPlace) , new SqlParameter("@DOB", DOB) , new SqlParameter("@Gender", Gender) , new SqlParameter("@Job", Job) , new SqlParameter("@Slary", Slary) , new SqlParameter("@Phone", Phone) , new SqlParameter("@Mobile", Mobile) , new SqlParameter("@Email", Email) , new SqlParameter("@MaritalStatus", MaritalStatus) , new SqlParameter("@ChildCount", ChildCount) , new SqlParameter("@IdentityImage", IdentityImage) , new SqlParameter("@PlaceAddress", PlaceAddress) , new SqlParameter("@ScientificQualifier", ScientificQualifier) , new SqlParameter("@Major", Major) , new SqlParameter("@IsActivated", IsActivated) , new SqlParameter("@NotActivatedReason", NotActivatedReason) , new SqlParameter("@Notes", Notes))); }
public bool InsertSupervisorData() { IdentityImage = BaseDataBase.CheckImageFile(IdentityImage); SupervisorID = BaseDataBase._StoredProcedureReturnable("sp_Add2Supervisor" , new SqlParameter("@SupervisorID", System.Data.SqlDbType.Int) , new SqlParameter("@FirstName", FirstName) , new SqlParameter("@LastName", LastName) , new SqlParameter("@BirthPlace", BirthPlace) , new SqlParameter("@DOB", DOB) , new SqlParameter("@Gender", Gender) , new SqlParameter("@Job", Job) , new SqlParameter("@Slary", Slary) , new SqlParameter("@Phone", Phone) , new SqlParameter("@Mobile", Mobile) , new SqlParameter("@Email", Email) , new SqlParameter("@MaritalStatus", MaritalStatus) , new SqlParameter("@ChildCount", ChildCount) , new SqlParameter("@IdentityImage", IdentityImage) , new SqlParameter("@PlaceAddress", PlaceAddress) , new SqlParameter("@ScientificQualifier", ScientificQualifier) , new SqlParameter("@Major", Major) , new SqlParameter("@IsActivated", IsActivated) , new SqlParameter("@NotActivatedReason", NotActivatedReason) , new SqlParameter("@Notes", Notes)); return(SupervisorID != null); }
public bool UpdatePersonQualificationData() { QualificationImage = BaseDataBase.CheckImageFile(QualificationImage, Qualification.GetQualificationByID(PersonQualificationID).QualificationImage); return(BaseDataBase._StoredProcedure("sp_UpdatePersonQualification" , new SqlParameter("@PersonQualificationID", PersonQualificationID) , new SqlParameter("@PersonID", PersonID) , new SqlParameter("@QualificationName", QualificationName) , new SqlParameter("@DateOfQualification", DateOfQualification) , new SqlParameter("@QualificationImage", QualificationImage) , new SqlParameter("@Notes", Notes))); }
public bool UpdateData() { impedingIdentityImage = BaseDataBase.CheckImageFile(impedingidentityimage, Impeding.GetImpedingByID(ID).impedingIdentityImage); return(BaseDataBase._StoredProcedure("sp_Updateimpeding" , new SqlParameter("@ID", ID) , new SqlParameter("@impedingType", impedingType) , new SqlParameter("@impedingDegree", impedingDegree) , new SqlParameter("@impedingIdentityID", impedingIdentityID) , new SqlParameter("@impedingIdentityImage", impedingIdentityImage) , new SqlParameter("@RelatedAssociation", RelatedAssociation) , new SqlParameter("@ImpedingDate", ImpedingDate) , new SqlParameter("@Notes", Notes) , new SqlParameter("@OrphanID", OrphanID))); }
public bool InsertData() { impedingIdentityImage = BaseDataBase.CheckImageFile(impedingidentityimage); ID = BaseDataBase._StoredProcedureReturnable("sp_Add2impeding" , new SqlParameter("@ID", System.Data.SqlDbType.Int) , new SqlParameter("@impedingType", impedingType) , new SqlParameter("@impedingDegree", impedingDegree) , new SqlParameter("@impedingIdentityID", impedingIdentityID) , new SqlParameter("@impedingIdentityImage", impedingIdentityImage) , new SqlParameter("@RelatedAssociation", RelatedAssociation) , new SqlParameter("@ImpedingDate", ImpedingDate) , new SqlParameter("@Notes", Notes) , new SqlParameter("@OrphanID", OrphanID)); return(ID != null); }
public bool InsertPersonQualificationData() { QualificationImage = BaseDataBase.CheckImageFile(QualificationImage); PersonQualificationID = BaseDataBase._StoredProcedureReturnable("sp_Add2PersonQualification" , new SqlParameter("@PersonQualificationID", System.Data.SqlDbType.Int) , new SqlParameter("@PersonType", PersonType) , new SqlParameter("@PersonID", PersonID) , new SqlParameter("@QualificationName", QualificationName) , new SqlParameter("@DateOfQualification", DateOfQualification) , new SqlParameter("@QualificationImage", QualificationImage) , new SqlParameter("@Notes", Notes)); if (PersonQualificationID == null) { return(false); } return(true); }