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(); }