public DataTable GetEntityData(object locationID, string syncDirection)
{
DataTable dtEntity = new DataTable();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlCloudconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_R_GETSYNC]";
cmd.Parameters.AddWithValue("@LocationID", locationID);
cmd.Parameters.AddWithValue("@LocationType", "BranchCounter");
cmd.Parameters.AddWithValue("@SyncDirection", syncDirection);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dtEntity);
}
}
}
catch (Exception ex)
{
throw new Exception("Error While Retreiving Entity data List", ex);
}
finally
{
SQLCon.SqlCloudconn().Close();
}
return(dtEntity);
}
public DataTable GetCounterList()
{
DataTable dtBranch = new DataTable();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlCloudconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_R_BRANCHCOUNTER]";
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dtBranch);
}
}
}
catch (Exception ex)
{
throw new Exception("Error While Retrieving Branch Counter List", ex);
}
finally
{
SQLCon.Sqlconn().Close();
}
return(dtBranch);
}
public DataTable GetEntityWiseData(object EntityName, object SyncDate, object BranchID)
{
DataTable dtEntity = new DataTable();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlCloudconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_R_GETSYNCDATA]";
cmd.Parameters.AddWithValue("@EntityName", EntityName);
cmd.Parameters.AddWithValue("@SyncDate", SyncDate);
cmd.Parameters.AddWithValue("@BranchID", BranchID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dtEntity);
}
}
}
catch (Exception ex)
{
throw new Exception($"Error While Retreiving Entity wise data List - {EntityName}", ex);
}
finally
{
SQLCon.SqlCloudconn().Close();
}
return(dtEntity);
}
public DataSet GetDaySequence(object branchCounterID)
{
DataSet dsRestoreData = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlCloudconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_R_POS_IMPORTDATA]";
cmd.Parameters.AddWithValue("@BranchCounterID", branchCounterID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsRestoreData);
}
}
}
catch (Exception ex)
{
throw new Exception("Error While getting restore data", ex);
}
finally
{
SQLCon.SqlCloudconn().Close();
}
return(dsRestoreData);
}
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.SqlCloudconn();
cmd.CommandType = CommandType.StoredProcedure;
EntityMapping map = entityMapping[entityName];
cmd.CommandText = map.ProcedureName;
cmd.Parameters.AddWithValue(map.ParameterName, dtEntityWiseData);
if (map.IncludeBranchCounterID)
{
cmd.Parameters.AddWithValue("@BranchCounterID", Utility.branchinfo.BranchCounterID);
}
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception("Error While saving Entity wise data List", ex);
}
finally
{
SQLCon.SqlCloudconn().Close();
}
}
public void UpdateEntitySyncStatus(object entitySyncStatusID, DateTime syncTime)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlCloudconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_U_ENTITYSYNCTIME]";
cmd.Parameters.AddWithValue("@EntitySyncStatusID", entitySyncStatusID);
cmd.Parameters.AddWithValue("@SyncTime", syncTime);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception("Error While saving Entity sync status", ex);
}
finally
{
SQLCon.SqlCloudconn().Close();
}
}
public void CheckOrAddHDDSerialNumber(object branchCounterID, string HDDSNo)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.SqlCloudconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[USP_U_BRANCHCOUNTER_HDDNO]";
cmd.Parameters.AddWithValue("@BranchCounterID", branchCounterID);
cmd.Parameters.AddWithValue("@HDDSNO", HDDSNo);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
SQLCon.SqlCloudconn().Close();
}
}
