//public void updateSections()
//{
// CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer();
// BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable;
// BMEBL.SetsystemDBTag = systemDBTag;
// BMEBL.SetUserCurrentInfo = this.UserCurrentInfo;
// List<string> Thelist = TProductionGlobal.getUserInfo(UserCurrentInfo.Connection).PlanBookSections;
// if (BMEBL.GetSectionsMO(Convert.ToString(_prodMonth), Thelist) == true)
// {
// tblSections = BMEBL.ResultsDataTable.Clone();
// tblSections = BMEBL.ResultsDataTable.Copy();
// }
//}
/// <summary>
/// Test if section planning is locked by another user. This will set the planning screen readonly label
/// </summary>
public clsResults isReadOnly()
{
var theResult = new clsResults();
theData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
theData.queryReturnType = MWDataManager.ReturnType.DataTable;
theData.SqlStatement = "SELECT * FROM SECTION WHERE Sectionid = '" + _sectionID + "' AND Prodmonth = " + _prodMonth + " AND PrePlanLockedBy<>''";
theData.ExecuteInstruction();
if (theData.ResultsDataTable.Rows.Count > 0 && theData.ResultsDataTable.Rows[0]["PrePlanLockedBy"].ToString() != UserCurrentInfo.UserID)
{
foreach (DataRow r in theData.ResultsDataTable.Rows)
{
theResult.Successfull = false;
theResult.Message.AppendLine("Section " + SectionName + " is set to read only by : " + r["PrePlanLockedBy"].ToString());
//_PlanningScreen.setReadonly(true,"Read Only Locked By : " + r["PrePlanLockedBy"].ToString());
}
}
else
{
theResult.Successfull = true;
}
return(theResult);
}
public static clsResults fnExecuteQuery(String strQuery, Boolean ConnectToDB = true)
{
clsResults oResults = new clsResults();
if (ConnectToDB)
{
DBManager.ConnectToDatabase();
}
try
{
DBManager.ExecuteQuery(strQuery);
oResults.ErrorCode = "0";
}
catch (Exception ex)
{
oResults.ErrorCode = "1";
oResults.ErrorMessage = ex.Message;
return(oResults);
}
finally
{
if (ConnectToDB)
{
DBManager.DisconnectToDataBase();
}
}
return(oResults);
}
public static clsResults fnSaveData(String strUserId, String strTableName, String[] strFields, String[] strValues, String strCriteria = "", String strPrimaryKey = "Id", Boolean ConnectToDB = true)
{
clsResults oResults = new clsResults();
if (strFields.Length != strValues.Length)
{
oResults.ErrorCode = "1";
oResults.ErrorMessage = "Fields and Values are not Equal";
return(oResults);
}
if (ConnectToDB)
{
DBManager.ConnectToDatabase();
}
try
{
if (strCriteria == "")
{
DBManager.ExecuteQuery(GetInsertQuery(strUserId, strTableName, strFields, strValues));
String SlQuery = "select " + strPrimaryKey + " from " + strTableName + " order by MDAT DESC";
oResults.ErrorCode = "0";
oResults.AdditionalInfo = DBManager.GetDataTable(SlQuery).Rows[0][0].ToString();
}
else
{
DBManager.ExecuteQuery(GetUpdateQuery(strUserId, strTableName, strFields, strValues, strCriteria));
//String SlQuery = "select " + strPrimaryKey + " from " + strTableName + " order by MDAT DESC";
oResults.ErrorCode = "0";
//oResults.AdditionalInfo = DBManager.ExecuteScalar(SlQuery);
}
}
catch (Exception ex)
{
oResults.ErrorCode = "1";
oResults.ErrorMessage = ex.Message;
return(oResults);
}
finally
{
if (ConnectToDB)
{
DBManager.DisconnectToDataBase();
}
}
return(oResults);
}
/// <summary>
/// Gest the current sections calendar dates start and end
/// </summary>
public clsResults ValidateSectionCalender()
{
clsResults theResults = new clsResults();
tblSectionStartEndDates = new DataTable();
CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer();
BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable;
BMEBL.SetsystemDBTag = systemDBTag;
BMEBL.SetUserCurrentInfo = this.UserCurrentInfo;
if (BMEBL.get_MinerSectionStartEndDates(PlanningSettings.ProdMonth, PlanningSettings.MOSectionID) == true)
{
tblSectionStartEndDates = BMEBL.ResultsDataTable;
}
if (tblSectionStartEndDates != null && tblSectionStartEndDates.Rows.Count > 0)
{
foreach (DataRow r in tblSectionStartEndDates.Rows)
{
if (r["StartDate"].ToString() != "") // test if dates are valid
{
theBeginDate = Convert.ToDateTime(r["StartDate"].ToString());
theEndDate = Convert.ToDateTime(r["EndDate"].ToString());
theResults.Successfull = true;
}
else
{
theResults.Successfull = false;
theResults.Message.AppendLine("The calendars for the selected section is invalid");
}
}
}
else
{
theResults.Successfull = false;
theResults.Message.AppendLine("The calendars for the selected section is invalid");
}
return(theResults);
}
public static clsResults fnSelectData(String strQuery)
{
DBManager.ConnectToDatabase();
clsResults oResults = new clsResults();
try
{
oResults.dtRecords = DBManager.GetDataTable(strQuery);
oResults.ErrorCode = "0";
}
catch (Exception ex)
{
DBManager.DisconnectToDataBase();
oResults.ErrorCode = "1";
oResults.ErrorMessage = ex.Message;
return(oResults);
}
DBManager.DisconnectToDataBase();
return(oResults);
}
public static clsResults fnDeleteData(String strTableName, String strCriteria = "")
{
String strQuery = "Delete From " + strTableName;
if (strCriteria != "")
{
strQuery += " Where " + strCriteria;
}
DBManager.ConnectToDatabase();
clsResults oResults = new clsResults();
try
{
int result = DBManager.ExecuteQuery(strQuery);
if (result == 0)
{
oResults.ErrorCode = "1";
oResults.ErrorMessage = "No Record Deleted";
}
else
{
oResults.ErrorCode = "0";
}
}
catch (Exception ex)
{
DBManager.RollBackTransaction();
oResults.ErrorCode = "1";
oResults.ErrorMessage = ex.Message;
return(oResults);
}
DBManager.DisconnectToDataBase();
return(oResults);
}
public List <clsResults> GetAll(string date, int eventid, int leagueid)
{
try
{
List <clsResults> objList = new List <clsResults>();
SqlCommand com = new SqlCommand("iBet_tblResult_GetsAll", conn.GetConn());
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Date", date);
com.Parameters.AddWithValue("@EventId", eventid);
com.Parameters.AddWithValue("@LeagueId", leagueid);
conn.OpenConn();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
clsResults obj = new clsResults();
if (dr["ResultId"] != DBNull.Value)
{
obj.ResultId = Convert.ToInt64(dr["ResultId"]);
}
if (dr["AwayName"] != DBNull.Value)
{
obj.AwayName = Convert.ToString(dr["AwayName"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
obj.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["EventId"] != DBNull.Value)
{
obj.EventId = Convert.ToInt32(dr["EventId"]);
}
if (dr["EventName"] != DBNull.Value)
{
obj.EventName = Convert.ToString(dr["EventName"]);
}
if (dr["FinalAway"] != DBNull.Value)
{
obj.FinalAway = Convert.ToString(dr["FinalAway"]);
}
if (dr["FinalHome"] != DBNull.Value)
{
obj.FinalHome = Convert.ToString(dr["FinalHome"]);
}
if (dr["FirstHaflAway"] != DBNull.Value)
{
obj.FirstHafAway = Convert.ToString(dr["FirstHaflAway"]);
}
if (dr["FirstHaflHome"] != DBNull.Value)
{
obj.FirstHaflHome = Convert.ToString(dr["FirstHaflHome"]);
}
if (dr["HomeName"] != DBNull.Value)
{
obj.HomeName = Convert.ToString(dr["HomeName"]);
}
if (dr["KickoffTime"] != DBNull.Value)
{
obj.KickoffTime = Convert.ToDateTime(dr["KickoffTime"]);
}
if (dr["LeagueId"] != DBNull.Value)
{
obj.LeagueId = Convert.ToInt32(dr["LeagueId"]);
}
if (dr["LeagueName"] != DBNull.Value)
{
obj.LeagueName = Convert.ToString(dr["LeagueName"]);
}
if (dr["MatchId"] != DBNull.Value)
{
obj.MatchId = Convert.ToInt64(dr["MatchId"]);
}
if (dr["Status"] != DBNull.Value)
{
obj.Status = Convert.ToString(dr["Status"]);
}
objList.Add(obj);
}
return(objList);
}
catch (Exception)
{
throw;
}
finally
{
conn.CloseConn();
}
}
