public bool Insert(KoreaRicNumInfo info)
{
try
{
using (SqlConnection conn = new SqlConnection(Config.ConnectionString))
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandText = "insert into ETI_Korea_ELW_Number(Date,WarrantAddRicNum,WarrantDropRicNum) values(@Date,@AddRicNum,@DropRicNum)";
comm.Parameters.Add(new SqlParameter("@Date", info.LauchDate));
comm.Parameters.Add(new SqlParameter("@AddRicNum", info.WarrantAddRicNum));
comm.Parameters.Add(new SqlParameter("@DropRicNum", info.WarrantDropRicNum));
int rowAffected = comm.ExecuteNonQuery();
if (rowAffected == 0)
{
return(false);
}
return(true);
}
}
}
catch (Exception)
{
return(false);
}
}
private void StartJob()
{
string date = DateTime.Today.ToString("yyyy-MM-dd");
KoreaRicNumInfo todayInfo = KoreaRicNumManager.GetByDate(date);
if (todayInfo != null)
{
string msg = string.Format("Please notice the task has been done today. Add number: {0}. Drop number: {1}.", todayInfo.WarrantAddRicNum, todayInfo.WarrantDropRicNum);
Logger.Log(msg, Logger.LogType.Warning);
}
int addNum = StartELWFM1AndFileBulkGenerateJob();
int dropNum = StartELWDropJob();
if ((addNum + dropNum) == 0)
{
string msg = "No ADD or DROP data grabbed today.";
Logger.Log(msg);
return;
}
string emaFolder = CreateFM1FileEmaDir();
TaskResultList.Insert(0, new TaskResultEntry("EMA Folder", "EMA Folder", emaFolder));
TaskResultList.Insert(0, new TaskResultEntry("BulkFile Folder", "BulkFile Folder", configObj.BulkFile));
TaskResultList.Insert(0, new TaskResultEntry("FM Folder", "FM Folder", configObj.FM));
TaskResultList.Insert(0, new TaskResultEntry("LOG", "LOG", Logger.FilePath));
KoreaRicNumInfo warrantRicNumInfo = new KoreaRicNumInfo(date, addNum, dropNum);
KoreaRicNumManager ricManager = new KoreaRicNumManager();
if (todayInfo == null)
{
ricManager.Insert(warrantRicNumInfo);
}
else
{
ricManager.ModifyByDate(date, addNum, dropNum);
}
string filename = "Korea FM for " + DateTime.Today.ToString("dd-MMM-yyyy", new CultureInfo("en-US")).Replace("-", " ") + " (Morning).xls";
string ipath = Path.Combine(configObj.FM, filename);
AddResult(Path.GetFileNameWithoutExtension(ipath), ipath, "FM File");
}
public List <KoreaRicNumInfo> GetAll()
{
List <KoreaRicNumInfo> infoList = new List <KoreaRicNumInfo>();
try
{
using (SqlConnection conn = new SqlConnection(Config.ConnectionString))
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
using (SqlCommand comm = new SqlCommand("select * from ETI_Korea_ELW_Number", conn))
{
using (SqlDataReader dr = comm.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
KoreaRicNumInfo info = new KoreaRicNumInfo();
info.LauchDate = Convert.ToString(dr["Date"]);
info.WarrantAddRicNum = Convert.ToInt32(dr["WarrantAddRicNum"]);
info.WarrantDropRicNum = Convert.ToInt32(dr["WarrantDropRicNum"]);
infoList.Add(info);
}
}
}
}
}
return(infoList);
}
catch (Exception)
{
return(null);
}
}
public static KoreaRicNumInfo GetByDate(string date)
{
try
{
using (SqlConnection conn = new SqlConnection(Config.ConnectionString))
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandText = "select * from ETI_Korea_ELW_Number where Date=@Date";
comm.Parameters.Add(new SqlParameter("@Date", date));
using (SqlDataReader dr = comm.ExecuteReader())
{
if (dr.HasRows && dr.Read())
{
KoreaRicNumInfo info = new KoreaRicNumInfo();
info.LauchDate = Convert.ToString(dr["Date"]);
info.WarrantAddRicNum = Convert.ToInt32(dr["WarrantAddRicNum"]);
info.WarrantDropRicNum = Convert.ToInt32(dr["WarrantDropRicNum"]);
return(info);
}
}
}
}
}
catch (Exception)
{
return(null);
}
return(null);
}
