internal bool insert()
{
string sql = "";
SqlCommand command;
var CL = new commonLogic();
SqlConnection cnn = CL.connect();
string id = HttpContext.Current.Session["id"].ToString();
try
{
string uploadFileName = uploadFile();
string DrillType = string.Join(",", TypeOfDrill);
Durationofdrill = CL.setDurationOfDrill(DurationofdrillMinutes, DurationofdrillSeconds);
string drillStatus = CL.GetDrillStatus(reportForQuanterEnding, DateTimeofDrill, DrillType, Durationofdrill);
string drillShift = CL.GetDrillShift(DateTimeofDrill);
sql = "INSERT INTO resdential_drill_log(user_id,program_address,program_location,drill_shift,report_for_quarter_ending,drill_status,type_of_drill,evacuation,name_of_program,date_time_of_drill,staff_ratio,duration_of_drill,drill_scenario,building_exit,egress_was_blocked,secondary_location,staff_signature,staff_signature_date,supervisor_signature,supervisor_signature_date,added_date,drill_was_during,name_of_staff,upload_survey) ";
sql += " OUTPUT INSERTED.ID VALUES(@user_id,@ProgramAddress,@ProgramLocation,@drillShift,@reportForQuanterEnding,@DrillStatus,@TypeOfDrill,@Evacuation,@NameofProgram,@DateTimeofDrill, @StaffRatio, @Durationofdrill,@DrillScenario, @BuildingExit,@EgressWasBlocked, @SecondaryLocation,@StaffSignature, @StaffSignatureDate,@SupervisorSignature,@SupervisorSignatureDate,GETDATE(),@DrillWasDuring,@NameofStaff,@upload_survey) ";
command = new SqlCommand(sql, cnn);
command.Parameters.AddWithValue("@user_id", id);
command.Parameters.AddWithValue("@ProgramAddress", ProgramAddress);
command.Parameters.AddWithValue("@ProgramLocation", Location);
command.Parameters.AddWithValue("@drillShift", drillShift);
command.Parameters.AddWithValue("@reportForQuanterEnding", DBNull.Value);
command.Parameters.AddWithValue("@DrillStatus", drillStatus);
command.Parameters.AddWithValue("@TypeOfDrill", DrillType);
command.Parameters.AddWithValue("@Evacuation", Evacuation);
command.Parameters.AddWithValue("@NameofProgram", NameofProgram);
command.Parameters.AddWithValue("@DateTimeofDrill", DateTimeofDrill);
command.Parameters.AddWithValue("@StaffRatio", StaffRatio);
if (Durationofdrill == null)
{
command.Parameters.AddWithValue("@Durationofdrill", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@Durationofdrill", Durationofdrill);
}
command.Parameters.AddWithValue("@DrillScenario", DrillScenario);
command.Parameters.AddWithValue("@BuildingExit", BuildingExit);
command.Parameters.AddWithValue("@EgressWasBlocked", EgressWasBlocked);
command.Parameters.AddWithValue("@SecondaryLocation", SecondaryLocation);
command.Parameters.AddWithValue("@StaffSignature", StaffSignature);
command.Parameters.AddWithValue("@StaffSignatureDate", StaffSignatureDate);
command.Parameters.AddWithValue("@SupervisorSignature", SupervisorSignature);
command.Parameters.AddWithValue("@SupervisorSignatureDate", SupervisorSignatureDate);
command.Parameters.AddWithValue("@DrillWasDuring", DrillWasDuring);
command.Parameters.AddWithValue("@NameofStaff", NameofStaff);
command.Parameters.AddWithValue("@upload_survey", uploadFileName);
command.CommandType = CommandType.Text;
int newId = Convert.ToInt32(command.ExecuteScalar());
if (newId < 1)
{
CL.getLog("Fail to insert");
return(false);
}
bool RDclient = true;//ResidentialDrillClients(newId);
bool RDUniqueID = updateUniqueId(newId);
if (RDclient == false || RDUniqueID == false)
{
CL.getLog("Fail to insert and update other tables");
return(false);
}
cnn.Close();
return(true);
}
catch (Exception e)
{
CL.getLog("error while inserting records in resdential_drill_log " + e);
cnn.Close();
return(false);
}
}