public ResultSet CreateHospital(HospitalModel model)
{
ResultSet result = new ResultSet();
try
{
SqlParameter[] parameters =
{
new SqlParameter("@MODE", "I"),
new SqlParameter("@HOSPITAL_ID", -1),
new SqlParameter("@HOSPITAL_NAME", model.Name),
new SqlParameter("@HOSPITAL_USERNAME", model.Username),
new SqlParameter("@PASSWORD", model.Password),
new SqlParameter("@CONTACT_NO", model.ContactNo),
new SqlParameter("@WEBSITE", model.Website),
new SqlParameter("@EMAIL", model.Email),
new SqlParameter("@LOCATION", model.Location),
new SqlParameter("@CREATED_IP", model.IpAddress)
};
_dao.ExecuteQuery(parameters, "PROC_CREATE_UPDATE_HOPITAL");
result.Success = true;
result.Message = "HOSPITAL ACCOUNT CREATED SUCCESSFULLY";
}
catch (System.Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public ResultSet RequestBlood(string id, int userId)
{
ResultSet result = new ResultSet();
try
{
string query = @"IF NOT EXISTS(SELECT TOP 1 1 FROM TBL_USER WHERE USER_ID=@USER_ID)
BEGIN
RAISERROR('USER DOES NOT EXISTS',16,1);
RETURN;
END
ELSE IF NOT EXISTS(SELECT TOP 1 1 FROM TBL_HOSPITAL_BLOOD_INFO WHERE BLOOD_INFO_ID=@BLOOD_INFO_ID)
BEGIN
RAISERROR('BLOOD INFO DOES NOT EXISTS',16,1);
RETURN;
END
ELSE IF NOT EXISTS(SELECT TOP 1 1 FROM TBL_HOSPITAL_BLOOD_INFO WHERE BLOOD_INFO_ID=@BLOOD_INFO_ID AND IS_ACTIVE=1)
BEGIN
RAISERROR('BLOOD INFO IS NOT VALID',16,1);
RETURN;
END
ELSE IF EXISTS(SELECT TOP 1 1 FROM TBL_REQUEST_BLOOD_HIST WHERE BLOOD_INFO_ID=@BLOOD_INFO_ID AND USER_ID=@USER_ID)
BEGIN
RAISERROR('CURRENT USER ALREADY REQUESTED THIS BLOOD SAMPLE',16,1);
RETURN;
END
ELSE BEGIN
INSERT INTO TBL_REQUEST_BLOOD_HIST(BLOOD_INFO_ID,USER_ID,AMOUNT,CREATED_DATE,IS_ACTIVE)
VALUES(@BLOOD_INFO_ID,@USER_ID,(SELECT TOP 1 AMOUNT FROM TBL_HOSPITAL_BLOOD_INFO WHERE BLOOD_INFO_ID=@BLOOD_INFO_ID),GETDATE(),1)
END";
SqlParameter[] sqlParameters =
{
new SqlParameter("@BLOOD_INFO_ID", id),
new SqlParameter("@USER_ID", userId),
};
_dao.ExecuteQuery(sqlParameters, query, isProc: false);
result.Success = true;
result.Message = "BLOOD SAMPLE REQUESTED SUCCESSFULLY";
}
catch (System.Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public ResultSet CreateBloddSample(BloodSampleModel model)
{
ResultSet result = new ResultSet();
try
{
string query =
@"
INSERT INTO TBL_HOSPITAL_BLOOD_INFO([HOSPITAL_ID],[BLOOD_GROUP],[AMOUNT] ,[UNIT],[AVAILABLE_LOCATION],[CONTACT_NO],[BLOOD_PROPERTY_ONE],[BLOOD_PROPERTY_TWO],[BLOOD_PROPERTY_THREE],[LATITUDE],[LONGITUDE],[CREATED_DATE],[IS_ACTIVE])
VALUES (@HOSPITAL_ID,@BLOOD_GROUP,@AMOUNT ,@UNIT,@AVAILABLE_LOCATION,@CONTACT_NO,@BLOOD_PROPERTY_ONE,@BLOOD_PROPERTY_TWO,@BLOOD_PROPERTY_THREE,@LATITUDE,@LONGITUDE,@CREATED_DATE,@IS_ACTIVE)
"
;
SqlParameter[] sqlParameters =
{
new SqlParameter("@HOSPITAL_ID", model.HospitalId),
new SqlParameter("@BLOOD_GROUP", model.BloodGroup),
new SqlParameter("@AMOUNT", model.Amount),
new SqlParameter("@UNIT", model.Unit),
new SqlParameter("@AVAILABLE_LOCATION", model.Location),
new SqlParameter("@CONTACT_NO", model.ContactNo),
new SqlParameter("@BLOOD_PROPERTY_ONE", model.BloodPropertyOne),
new SqlParameter("@BLOOD_PROPERTY_TWO", model.BloddPropertyTwo),
new SqlParameter("@BLOOD_PROPERTY_THREE", model.BloodPropertyThree),
new SqlParameter("@LATITUDE", model.Latitude),
new SqlParameter("@LONGITUDE", model.Longitude),
new SqlParameter("@CREATED_DATE", System.DateTime.Now),
new SqlParameter("@IS_ACTIVE", true)
};
_dao.ExecuteQuery(sqlParameters, query, isProc: false);
result.Success = true;
result.Message = "BLOOD SAMPLE SAVED SUCCESSFULLY";
}
catch (System.Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
