public bool Insert(HKRicNumInfo info)
{
try
{
using (MySqlConnection conn = new MySqlConnection(Config.ConnectionString))
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
using (MySqlCommand comm = new MySqlCommand())
{
comm.Connection = conn;
comm.CommandText = "insert into HKRicNumInfo(Date,CBBCRicNum,WarrantRicNum) values(@Date,@CBBCRicNum,@WarrantRicNum)";
comm.Parameters.Add(new MySqlParameter("@Date", info.LauchDate));
comm.Parameters.Add(new MySqlParameter("@CBBCRicNum", info.CBBCRicNum));
comm.Parameters.Add(new MySqlParameter("@WarrantRicNum", info.WarrantRicNum));
int rowAffected = comm.ExecuteNonQuery();
if (rowAffected == 0)
{
return(false);
}
return(true);
}
}
}
catch (Exception)
{
return(false);
}
}
public void StartFMAndBulkFileGeneratorJob()
{
if (taskList == null || taskList.Count == 0)
{
Logger.LogErrorAndRaiseException("Please select at least one job: CBBCGenerator, WarrantGenerator or BulkFileGenerator");
}
for (int i = 0; i < taskList.Count; i++)
{
if (taskList[i].Contains("CBBC"))
{
cbbcGenerator.Start();
RicListCBBC = cbbcGenerator.RicList;
ChineseListCBBC = cbbcGenerator.RicChineseList;
}
else if (taskList[i].Contains("Warrant"))
{
warrantGenerator.Start();
RicListWarrant = warrantGenerator.RicList;
ChineseListWarrant = warrantGenerator.RicChineseList;
}
else
{
bulkFileGenerator.RicListCbbc = RicListCBBC;
bulkFileGenerator.RicListWarrant = RicListWarrant;
bulkFileGenerator.ChineseListCbbc = ChineseListCBBC;
bulkFileGenerator.ChineseListWarrant = ChineseListWarrant;
bulkFileGenerator.Start();
}
}
string date = DateTime.Now.ToString("yyyy_MMM_dd");
HKRicNumInfo cbbcRicNumInfo = new HKRicNumInfo(date, RicListCBBC.Count, RicListWarrant.Count);
HKRicNumManager ricManager = new HKRicNumManager();
bool isSuccess = false;
if (ricManager.GetByDate(date) == null)
{
isSuccess = ricManager.Insert(cbbcRicNumInfo);
}
else
{
isSuccess = ricManager.ModifyByDate(date, RicListCBBC.Count, RicListWarrant.Count);
}
}
public List <HKRicNumInfo> GetAll()
{
List <HKRicNumInfo> infoList = new List <HKRicNumInfo>();
try
{
using (MySqlConnection conn = new MySqlConnection(Config.ConnectionString))
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
using (MySqlCommand comm = new MySqlCommand("select * from HKRicNumInfo", conn))
{
using (MySqlDataReader dr = comm.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
HKRicNumInfo info = new HKRicNumInfo();
info.LauchDate = Convert.ToString(dr["Date"]);
info.CBBCRicNum = Convert.ToInt32(dr["CBBCRicNum"]);
info.WarrantRicNum = Convert.ToInt32(dr["WarrantRicNum"]);
infoList.Add(info);
}
}
}
}
}
return(infoList);
}
catch (Exception)
{
return(null);
}
}
public HKRicNumInfo GetByDate(string date)
{
try
{
using (MySqlConnection conn = new MySqlConnection(Config.ConnectionString))
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
using (MySqlCommand comm = new MySqlCommand())
{
comm.Connection = conn;
comm.CommandText = "select * from HKRicNumInfo where Date=@Date";
comm.Parameters.Add(new MySqlParameter("@Date", date));
using (MySqlDataReader dr = comm.ExecuteReader())
{
if (dr.HasRows && dr.Read())
{
HKRicNumInfo info = new HKRicNumInfo();
info.LauchDate = Convert.ToString(dr["Date"]);
info.CBBCRicNum = Convert.ToInt32(dr["CBBCRicNum"]);
info.WarrantRicNum = Convert.ToInt32(dr["WarrantRicNum"]);
return(info);
}
}
}
}
}
catch (Exception)
{
return(null);
}
return(null);
}
public void UpdateDatabase()
{
HKRicNumInfo cbbcRicNumInfo = new HKRicNumInfo();
}
