public DataTable GetSyncStatus()
{
DataTable dtSyncStatus = new DataTable();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlCloudConn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_R_SHOWSYNC]";
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dtSyncStatus);
}
}
}
catch (Exception ex)
{
throw new Exception("Error While sync status from cloud database", ex);
}
finally
{
SQLCon.SqlCloudConn().Close();
}
return(dtSyncStatus);
}
public void DeleteSyncStatus(object LocationID)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlCloudConn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_D_SYNCSTATUS]";
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception("Error While deleteing sync status from cloud database", ex);
}
finally
{
SQLCon.SqlCloudConn().Close();
}
}
