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