public DataTable GetEntityWiseData(object EntityName, object SyncDate)
{
DataTable dtEntity = new DataTable();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlSyncConn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_R_GETSYNCDATA]";
cmd.Parameters.AddWithValue("@EntityName", EntityName);
cmd.Parameters.AddWithValue("@SyncDate", SyncDate);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dtEntity);
}
}
}
catch (Exception ex)
{
throw new Exception("Error While Retreiving Entity wise data List", ex);
}
finally
{
SQLCon.SqlSyncConn().Close();
}
return(dtEntity);
}
public void SaveData(string entityName, DataTable dtEntityWiseData)
{
if (dtEntityWiseData?.Rows.Count == 0 || !entityMapping.ContainsKey(entityName))
{
return;
}
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlSyncConn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = entityMapping[entityName].ProcedureName;
cmd.Parameters.AddWithValue(entityMapping[entityName].ParameterName, dtEntityWiseData);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception($"Error While saving Entity {entityName} wise data List", ex);
}
finally
{
SQLCon.SqlSyncConn().Close();
}
}
public void ClearOldData()
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlSyncConn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "POS_USP_D_OLD_DATA";
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception($"Error While clearing old data", ex);
}
finally
{
SQLCon.SqlSyncConn().Close();
}
}
