internal bool SubmitActivityAttendance(SubmitActivityAttendanceModal submitActivityAttendanceModal)
{
var tableResponse = _dbConnection.GetModelDetails(RawSQL.GetVoidedAttendance(submitActivityAttendanceModal.ActivityDate, submitActivityAttendanceModal.ActivityCode));
var checkRec = tableResponse.AsEnumerable().FirstOrDefault();
if (checkRec != null)
{
throw new CustomException("Selected Activity is voided, unable to post attendance");
}
return(_dbConnection.SaveActivityAttendance(submitActivityAttendanceModal));
}
public bool SaveActivityAttendance(SubmitActivityAttendanceModal submitActivityAttendanceModal)
{
int final = 0;
try
{
using (var connection = new OleDbConnection(connString))
{
connection.Open();
using (var cmd = new OleDbCommand(@"Insert into Act2018 (Roll_NO, Act_cd, Act_Date) VALUES (@Roll_NO, @Act_cd, @Act_Date)", connection))
{
cmd.CommandTimeout = 300;
Parallel.ForEach(submitActivityAttendanceModal.RollNoList, rollNo =>
{
lock (lockObj)
{
cmd.Parameters.Clear();
cmd.Parameters.AddRange(new OleDbParameter[]
{
new OleDbParameter {
ParameterName = "@Roll_NO", Value = rollNo
},
new OleDbParameter {
ParameterName = "@Act_cd", Value = submitActivityAttendanceModal.ActivityCode
},
new OleDbParameter {
ParameterName = "@Act_Date", Value = submitActivityAttendanceModal.ActivityDate
},
});
cmd.ExecuteNonQueryAsync();
}
});
//foreach (var rollNo in submitActivityAttendanceModal.RollNoList)
//{
// cmd.Parameters.Clear();
// cmd.Parameters.AddRange(new OleDbParameter[]
// {
// new OleDbParameter { ParameterName = "@Roll_NO", Value = rollNo },
// new OleDbParameter { ParameterName = "@Act_cd", Value = submitActivityAttendanceModal.ActivityCode },
// new OleDbParameter { ParameterName = "@Act_Date", Value = submitActivityAttendanceModal.ActivityDate },
// });
// cmd.ExecuteNonQuery();
//}
}
//return Task.FromResult(bool);
return(true);
}
}
catch (Exception ex)
{
_logger.LogError($"$$$SaveActivityAttend$$$####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####");
return(false);
}
}
public IActionResult DeleteSavedAttendance(SubmitActivityAttendanceModal deleteSavedAttendance)
{
var result = new RequestResult <bool>()
{
Data = _attendanceManager.DeleteSavedAttendance(deleteSavedAttendance),
Message = "Success",
Success = true
};
return(Ok(result));
}
public IActionResult SubmitActivityAttendance(SubmitActivityAttendanceModal submitActivityAttendanceModal)
{
var result = new RequestResult <bool>()
{
Data = _attendanceManager.SubmitActivityAttendance(submitActivityAttendanceModal),
Message = "Success",
Success = true
};
return(Ok(result));
}
internal bool DeleteSavedAttendance(SubmitActivityAttendanceModal deleteSavedAttendance)
{
if (deleteSavedAttendance.RollNoList.Count > 0)
{
_dbConnection.DeleteSavedAttendance(deleteSavedAttendance);
}
if (deleteSavedAttendance.Name.Count > 0)
{
_dbConnection.DeleteVisitorsSavedAttendance(deleteSavedAttendance);
}
return(true);
}
internal int DeleteSavedAttendance(SubmitActivityAttendanceModal obj)
{
int final = 0;
List <int> validRollNum = obj.RollNoList.Where(s => s != 0).Select(s => s).ToList();
try
{
using (var connection = new OleDbConnection(connString))
{
connection.Open();
using (var cmd = new OleDbCommand("DELETE FROM Act2018 WHERE Act_Date = @Act_Date and Roll_NO = @Roll_NO and Act_cd = @Act_cd", connection))
{
cmd.Connection = connection;
cmd.CommandTimeout = 300;
for (int i = 0; i < validRollNum.Count(); i++)
{
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@Act_Date", Value = (obj.ActivityDate), OleDbType = OleDbType.Date
});
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@Roll_No", Value = validRollNum[i], OleDbType = OleDbType.SmallInt
});
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@Act_cd", Value = obj.ActivityCode, OleDbType = OleDbType.WChar
});
final += cmd.ExecuteNonQuery();
}
}
return(final);
}
}
catch (Exception ex)
{
_logger.LogError($"ManageActivity####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####");
return(0);
}
}
internal int DeleteVisitorsSavedAttendance(SubmitActivityAttendanceModal obj)
{
int final = 0;
try
{
using (var connection = new OleDbConnection(connString))
{
connection.Open();
using (var cmd = new OleDbCommand("DELETE FROM VisitorOD WHERE Act_Date = @Act_Date and VisitorName = @VisitorName and Act_cd = @Act_cd", connection))
{
cmd.Connection = connection;
cmd.CommandTimeout = 300;
for (int i = 0; i < obj.Name.Count(); i++)
{
cmd.Parameters.Clear();
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@Act_Date", Value = (obj.ActivityDate), OleDbType = OleDbType.Date
});
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@VisitorName", Value = obj.Name[i], OleDbType = OleDbType.VarChar
});
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@Act_cd", Value = obj.ActivityCode, OleDbType = OleDbType.WChar
});
final += cmd.ExecuteNonQuery();
}
}
return(final);
}
}
catch (Exception ex)
{
_logger.LogError($"ManageActivity####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####");
return(0);
}
}
public bool DeleteSavedAttendance(SubmitActivityAttendanceModal deleteSavedAttendance)
{
return(_attendanceDataAccess.DeleteSavedAttendance(deleteSavedAttendance));
}
public bool SubmitActivityAttendance(SubmitActivityAttendanceModal submitActivityAttendanceModal)
{
return(_attendanceDataAccess.SubmitActivityAttendance(submitActivityAttendanceModal));
}