public ReturnClass.ReturnBool insert_action(bl_RTIDataForApplicant bl1)
{
string str = @"insert into rti_data_for_applicant
(rti_data_id, rti_id, action_id, action_file_id, rti_prepared_emp, result_description, IsFileUpload, IsMeetingFix, MeetingDate,
IsAdditionalFees, FeesAmount, ClientOS, ClientIP, ClientBrowser, ClientAgent ) values
( @rti_data_id, @rti_id, @action_id, @action_file_id, @rti_prepared_emp, @result_description, @IsFileUpload, @IsMeetingFix, @MeetingDate,
@IsAdditionalFees, @FeesAmount, @client_os, @ipaddress, @client_browser,@useragent )";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("rti_data_id", bl1.RTI_data_id),
new MySqlParameter("rti_id", bl1.Rti_id),
new MySqlParameter("action_id", bl1.Action_id),
new MySqlParameter("action_file_id", bl1.RTI_fileID),
new MySqlParameter("rti_prepared_emp", bl1.Userid),
new MySqlParameter("result_description", bl1.Result_description),
new MySqlParameter("IsFileUpload", bl1.Is_file_upload),
new MySqlParameter("IsMeetingFix", bl1.IsMeeting),
new MySqlParameter("MeetingDate", bl1.Meeting_date),
new MySqlParameter("IsAdditionalFees", bl1.IsAdditionalFees),
new MySqlParameter("FeesAmount", bl1.Fees_amount),
new MySqlParameter("client_os", bl1.Useros),
new MySqlParameter("ipaddress", bl1.Ipaddress),
new MySqlParameter("client_browser", bl1.User_browser),
new MySqlParameter("useragent", bl1.Useragent)
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
public ReturnClass.ReturnBool insert_action_file(bl_RTIDataForApplicant bl1)
{
string str = @"insert into action_files
( action_fileID, fileName, fileType, fileData, FileDescription, action_id, emp_mapping_id, rti_id )
values
( @action_file_id, @file_name, @file_type, @file_data, @file_description, @action_id, @emp_map_id, @rti_id)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("action_file_id", bl1.RTI_fileID),
new MySqlParameter("file_name", bl1.RTI_fileName),
new MySqlParameter("file_type", bl1.RTI_fileType),
new MySqlParameter("file_data", bl1.RTI_fileData),
new MySqlParameter("file_description", bl1.FileDescription),
new MySqlParameter("action_id", bl1.Action_id),
new MySqlParameter("emp_map_id", bl1.Office_mapping_id),
new MySqlParameter("rti_id", bl1.Rti_id)
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
public ReturnClass.ReturnBool Insert_Action_Info(bl_RTIDataForApplicant bl)
{
using (TransactionScope transScope = new TransactionScope())
{
//#region Status IS Pending
rb.status = true;
if (bl.Is_file_upload == "Y")
{
rb = insert_action_file(bl);
}
if (rb.status == true)
{
rb = insert_action(bl);
if (rb.status == true)
{
transScope.Complete();
}
}
}
return(rb);
}
