public string getIDbyName(string projectName)
{
string projectID = "";
string sql = string.Format("SELECT projectID from Project where projectName = {1}", projectName);
using (Dbconn) {
MySqlCommand cmd = new MySqlCommand(sql);
Dbconn.Open();
cmd.Connection = Dbconn;
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
projectID = reader.GetString(0);
}
else
{
projectID = UniqueIdFactory.RandomString(10);
}
}
}
return(projectID);
}
public int AddWork(string projectName, DateTime date, string type, DateTime beginTime,
DateTime endTime, string description, double priceBeforeTax, string paymentState)
{
ProjecRepository projecRepository = new ProjecRepository(ConnectionString);
String projectID = projecRepository.getIDbyName(projectName);
string sql = string.Format("INSERT INTO Work VALUES({0},{1},{2},{3},{4},{5},{6},{7},{8})",
UniqueIdFactory.RandomString(10), //0 WorKid
projectID, //1
date, //2
type, //3
beginTime, //4
endTime, //5
description, //6
priceBeforeTax, //7
paymentState //8
);
using (Dbconn)
{
Dbconn.Open();
MySqlCommand cmd = new MySqlCommand(sql);
cmd.Connection = Dbconn;
return(cmd.ExecuteNonQuery());
}
}
public Work(string projectID, DateTime date, DateTime beginTime, DateTime endTime, string description, double priceBeforeTax, string paymentState)
{
this.WorkID = UniqueIdFactory.RandomString(10);
this.ProjectID = projectID;
this.Date = date;
this.BeginTime = beginTime;
this.EndTime = endTime;
this.WorkingTime = WorkingTime;
this.PriceBeforeTax = priceBeforeTax;
this.PaymentState = paymentState;
}