public static string TimeSpanString(object val)
{
try
{
if (val == DBNull.Value)
{
return("");
}
if (val == null)
{
return("");
}
if ((val + "").Equals(""))
{
return("");
}
if ((val + "").Equals("0"))
{
return("");
}
return(ConvertTo.TimeSpanVal(val).ToString(@"hh\:mm"));
}
catch (Exception ex)
{
PrintLogWinForms.PrintLog("ConvertTo => TimeSpanString => Exception : " + ex);
}
return("");
}
public static ExecuteResult DeleteAttendance(int _serial_id)
{
RepGen reposGen = new Repository.RepGen();
DynamicParameters param = new DynamicParameters();
param.Add("@serial_id", _serial_id);
PrintLogWinForms.PrintLog("Delete From EmployeeAttendance Where serial_id=" + _serial_id + "");
return(reposGen.ExecuteNonQuery_Query("Delete From EmployeeAttendance Where serial_id=" + _serial_id + "", param));
}
public List <T> returnListClass_SP(string query, DynamicParameters param)
{
try
{
connection();
con.Open();
IList <T> Tlista = SqlMapper.Query <T>(con, query, param, null, true, null, commandType: CommandType.StoredProcedure).ToList();
con.Close();
return(Tlista.ToList());
}
catch (Exception ex)
{
PrintLogWinForms.PrintLog("returnListClass_SP => Exception => query : " + query);
PrintLogWinForms.PrintLog("returnListClass_SP => Exception => " + ex);
}
return(null);
}
public T returnClass_SP(string query, DynamicParameters param)
{
try
{
connection();
con.Open();
// return this.con.Query( query, param, null, true, null, commandType: CommandType.StoredProcedure).FirstOrDefault();
T Tlista = SqlMapper.Query <T>(con, query, param, null, true, null, commandType: CommandType.StoredProcedure).FirstOrDefault();
con.Close();
return(Tlista);
}
catch (Exception ex)
{
PrintLogWinForms.PrintLog("returnClass_SP => Exception => query : " + query);
PrintLogWinForms.PrintLog("returnClass_SP => Exception => " + ex);
}
return(null);
}
public async Task <List <T> > returnListClass_SP_Async(string query, DynamicParameters param)
{
try
{
connection();
con.Open();
var Tlista = await SqlMapper.QueryAsync <T>(con, query, param, null, null, commandType : CommandType.StoredProcedure);
con.Close();
return(Tlista.ToList());
}
catch (Exception ex)
{
PrintLogWinForms.PrintLog("returnListClass_SP => Exception => query : " + query);
PrintLogWinForms.PrintLog("returnListClass_SP => Exception => " + ex);
}
return(null);
}
public T1 returnClass_1 <T1>(string query, DynamicParameters param)
{
try
{
connection();
con.Open();
T1 Tlista = SqlMapper.Query <T1>(con, query, param, null, true, null, commandType: CommandType.Text).FirstOrDefault();
con.Close();
return(Tlista);
}
catch (Exception ex)
{
PrintLogWinForms.PrintLog("returnClass_1 => Exception => query : " + query);
PrintLogWinForms.PrintLog("returnClass_1 => Exception => " + ex);
}
return(default(T1));
}
public object returnScalar(string query, DynamicParameters param)
{
try
{
connection();
con.Open();
object rtn = SqlMapper.Query <object>(con, query, param, null, true, null, commandType: CommandType.Text);
con.Close();
return(rtn);
}
catch (Exception ex)
{
PrintLogWinForms.PrintLog("returnScalar => Exception => query : " + query);
PrintLogWinForms.PrintLog("returnScalar => Exception => " + ex);
}
return(null);
}
public static TimeSpan?TimeSpanVal_Null(object val)
{
try
{
if (val != null)
{
return(TimeSpan.Parse(val + ""));
}
else
{
PrintLogWinForms.PrintLog("ConvertValueTo.TimeSpanVal_Null : val is NULL");
return(null);
}
}
catch (Exception ex)
{
PrintLogWinForms.PrintLog("ConvertValueTo.TimeSpanVal_Null => Exception => val " +
": " + val + "" + "");
PrintLogWinForms.PrintLog("ConvertValueTo.TimeSpanVal_Null => Exception : " + ex.Message + "");
}
return(null);
}
