private void btnSendDataToB_Click_1(object sender, EventArgs e)
{
//dùng delegate send message từ frmA sang frmB
//khởi tạo mới một delegate sau đó truyền hàm FunDataB từ formB sang
// truyền vào giá trị của txtA vào trong dataSend
//frmB sẽ nhận giá trị của txtA thông qua hàm FunDataB và hiển thị lên frmB
SendDataAToB dataSend = new SendDataAToB(myFrmB.FunDataB);
dataSend(this.txtA);
//hàm save message vào db
FormContent message = new FormContent();
message.messageText = "A: " + txtA.Text;
idaoFrm.addMessage(message);
loadData();
myFrmB.loadData();
PassIdFormA dataObject = new PassIdFormA(myFrmB.FunObjectB);
dataObject(this);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["FormReply"] == null)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('錯誤，請重新選擇');window.location='/songlist';</script>");
Response.Redirect("/songlist");
return;
}
FormReply = (FormContent)Session["FormReply"];
if (FormReply == null)
{
return;
}
DateLabel.Text = "傳情日期：" + DateString[FormReply.Date - 1];
ClassLabel.Text = "傳情時間：" + ClassString[FormReply.Class - 2];
TeamLabel.Text = "傳情歌手：" + FormReply.TeamMemberName;
SongLabel.Text = "傳情歌曲：" + FormReply.SongName;
CategoryLabel.Text = "歌曲分類：" + FormReply.Category;
PlaceLabel.Text = "傳情地點：" + FormReply.Place;
ClassNameLabel.Text = "課堂名稱：" + FormReply.ClassName;
GeneralLessonLabel.Text = "是否為通識課：" + GereralLessonString[FormReply.GeneralLesson];
NameLabel.Text = "傳情者姓名：" + FormReply.Name;
DepartmentGradeLabel.Text = "傳情者系級：" + FormReply.DepartGrade;
PhoneLabel.Text = "傳情者手機：" + FormReply.Phone;
EmailLabel.Text = "傳情者Email：" + FormReply.Email;
SentNameLabel.Text = "被傳情者姓名：" + FormReply.SentName;
SentDepartmentGradeLabel.Text = "被傳情者系級：" + FormReply.SentDepartGrade;
SentPhoneLabel.Text = "被傳情者手機：" + FormReply.SentPhone;
SentEmailLabel.Text = "被傳情者Email：" + FormReply.SentEmail;
PayDayLabel.Text = "前往攤位繳費時間：" + ReserveString[FormReply.PayDay - 1];
SpecialRequestLabel.Text = "特殊需求：<br/>" + FormReply.SpecialRequest;
RemarkLabel.Text = "備註：<br/>" + FormReply.Remark.Replace(Environment.NewLine, "<br />");
}
}
internal CalcGenerator(FormContent formContent, string outDir)
: base(formContent, outDir)
{
}
private void FillFormContent(RaeClassContentType contentType, ref FormContent formContent)
{
formContent.fnumber = serialNumberRepository.GetSerialNumber(contentType);
formContent.frecordFileId1 = formContent.frecordFileId1;
formContent.frecordFileId2 = formContent.frecordFileId2;
}
protected static string FullOutDir(FormContent fc, string baseOutDir)
{
return(Path.Combine(Path.Combine(Path.Combine(baseOutDir, fc.Organization), fc.DocType), fc.Version));
}
internal BaseGenerator(FormContent formContent, string outDir)
{
Directory.CreateDirectory(outDir);
this.FormContent = formContent;
this.OutputDirectory = FullOutDir(formContent, outDir);
}
protected void Page_Load(object sender, EventArgs e)
{
int RID = TryToParse(Request.Form["RID"]); /*post method*/
string Phone = Request.Form["Phone"];
string Name = Request.Form["Name"];
if (RID <= 0 || Phone == null || Name == null)
{
return;
}
if (Session["QueryOrderRIDList"] == null)
{
return;
}
else
{
List <int> RIDSessionList = (List <int>)Session["QueryOrderRIDList"];
if (!RIDSessionList.Contains(RID))
{
return;
}
}
string strConn = ConfigurationManager.ConnectionStrings["LoveCarrierConnectionString"].ConnectionString;
SqlConnection myConn = new SqlConnection(strConn);
try
{
myConn.Open();
String strSQL = @"SELECT Day,Class,TeamMember1,TeamMember2,SongName,Category,Place,ClassName,GeneralLesson,Name,DepartGrade,Phone,Email,SentName,SentDepartGrade,SentPhone,SentEmail,PayDay,SpecialRequest,Remark,IsPaid from [Reserve],[Song],[Team] WHERE Reserve.TID = Team.Tid and Reserve.SID = Song.SID and Reserve.RID = @RID and Reserve.Name = @Name and Reserve.Phone = @Phone";
SqlCommand myCommand = new SqlCommand(strSQL, myConn);
myCommand.Parameters.AddWithValue("@RID", RID);
myCommand.Parameters.AddWithValue("@Name", Name);
myCommand.Parameters.AddWithValue("@Phone", Phone);
FormContent Form = new FormContent();
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
myDataReader.Read();
FormContent FormReply = new FormContent(
Convert.ToInt32(myDataReader["Day"].ToString()),
Convert.ToInt32(myDataReader["Class"].ToString()),
0,
myDataReader["TeamMember1"].ToString() + " " + myDataReader["TeamMember2"].ToString(),
0,
myDataReader["SongName"].ToString(),
myDataReader["Category"].ToString(),
myDataReader["Place"].ToString(),
myDataReader["ClassName"].ToString(),
Convert.ToInt32(myDataReader["GeneralLesson"].ToString()),
myDataReader["Name"].ToString(),
myDataReader["DepartGrade"].ToString(),
myDataReader["Phone"].ToString(),
myDataReader["Email"].ToString(),
myDataReader["SentName"].ToString(),
myDataReader["SentDepartGrade"].ToString(),
myDataReader["SentPhone"].ToString(),
myDataReader["SentEmail"].ToString(),
Convert.ToInt32(myDataReader["PayDay"].ToString()),
myDataReader["SpecialRequest"].ToString(),
myDataReader["Remark"].ToString(),
Convert.ToInt32(myDataReader["IsPaid"])
);
JavaScriptSerializer js = new JavaScriptSerializer();
string strJson = js.Serialize(FormReply);
Response.Write(strJson);
}
//Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
//Response.End();
}
finally
{
myConn.Close();
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
/*check if repeat*/
bool IsReserved = false;
bool IsFull = false;
string connectionString = ConfigurationManager.ConnectionStrings["LoveCarrierConnectionString"].ConnectionString;
SqlConnection Connection = new SqlConnection(connectionString);
try
{
Connection.Open();
String strSQL = @"SELECT count(1) from [Reserve] WHERE Reserve.Day = @Date and Reserve.Class = @Class and Reserve.TID = @Team";
SqlCommand myCommand = new SqlCommand(strSQL, Connection);
myCommand.Parameters.AddWithValue("@Date", Convert.ToInt32(DateHd.Value));
myCommand.Parameters.AddWithValue("@Class", Convert.ToInt32(ClassHd.Value));
myCommand.Parameters.AddWithValue("@Team", Convert.ToInt32(TeamHd.Value));
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
myDataReader.Read();
if (myDataReader[0].ToString() != "0")
{
IsReserved = true;
}
}
if (IsReserved)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('本時段您指定的傳情歌手已被他人選歌，請重新選擇...');window.location='/songlist';</script>");
//Response.Redirect("/songlist");
return;
}
//strSQL = @"SELECT SongCount from [SongTotal] WHERE Day = @Date and Class = @Class";
//myCommand = new SqlCommand(strSQL, Connection);
//myCommand.Parameters.AddWithValue("@Date", Convert.ToInt32(DateHd.Value));
//myCommand.Parameters.AddWithValue("@Class", Convert.ToInt32(ClassHd.Value));
//using(SqlDataReader myDataReader = myCommand.ExecuteReader())
//{
// myDataReader.Read();
// if(Convert.ToInt32(myDataReader[0].ToString()) >= 10) IsFull = true;
//}
//if(IsFull)
//{
// ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('本時段可選歌數已滿，請重新選擇...');window.location='/songlist';</script>");
// //Response.Redirect("/songlist");
// return;
//}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('連線錯誤');window.location='/songlist';</script>");
//Response.Redirect("/songlist");
return;
}
finally
{
Connection.Close();
}
/*Fill Session to Send*/
if (!IsReserved && !IsFull)
{
bool isRemark = false;
string SpecialRequestText = "";
for (int i = 0; i < SpecialRequestCheckBox.Items.Count; i++)
{
if (SpecialRequestCheckBox.Items[i].Selected)
{
isRemark = true;
SpecialRequestText += "[" + SpecialRequestCheckBox.Items[i].Value + "] ";
}
}
if (!isRemark)
{
SpecialRequestText = "無";
}
FormContent FormReply = new FormContent(
Convert.ToInt32(DateHd.Value),
Convert.ToInt32(ClassHd.Value),
Convert.ToInt32(TeamHd.Value),
TeamLabel.Text,
Convert.ToInt32(SongHd.Value),
SongLabel.Text,
CategoryLabel.Text,
PlaceTextBox.Text,
ClassNameTextBox.Text,
Convert.ToInt32(GeneralLessonDropDownList.SelectedValue),
NameTextBox.Text,
DepartmentGradeTextBox.Text,
PhoneTextBox.Text,
EmailTextBox.Text,
SentNameTextBox.Text,
SentDepartmentGradeTextBox.Text,
SentPhoneTextBox.Text,
SentEmailTextBox.Text,
Convert.ToInt32(PayDayDropDownList.SelectedValue),
SpecialRequestText,
RemarkTextBox.Text,
0
);
Session["FormReply"] = FormReply;
Response.Redirect("/confirm");
}
return;
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
if (Session["FormReply"] == null)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('錯誤，請重新選擇');window.location='/songlist';</script>");
Response.Redirect("/songlist");
return;
}
FormReply = (FormContent)Session["FormReply"];
int Date = FormReply.Date;
int Class = FormReply.Class;
int Team = FormReply.Team;
int Song = FormReply.Song;
string Place = FormReply.Place;
string ClassName = FormReply.ClassName;
int GeneralLesson = FormReply.GeneralLesson;
string Name = FormReply.Name;
string DepartGrade = FormReply.DepartGrade;
string Phone = FormReply.Phone;
string Email = FormReply.Email;
string SentName = FormReply.SentName;
string SentDepartGrade = FormReply.SentDepartGrade;
string SentPhone = FormReply.SentPhone;
string SentEmail = FormReply.SentEmail;
int PayDay = FormReply.PayDay;
string SpecialRequest = FormReply.SpecialRequest;
string Remark = FormReply.Remark;
bool IsReserved = false;
bool IsFull = false;
Session.Clear();
string connectionString = ConfigurationManager.ConnectionStrings["LoveCarrierConnectionString"].ConnectionString;
SqlConnection Connection = new SqlConnection(connectionString);
try
{
Connection.Open();
String strSQL = @"SELECT count(1) from [Reserve] WHERE Reserve.Day = @Date and Reserve.Class = @Class and Reserve.TID = @Team";
SqlCommand myCommand = new SqlCommand(strSQL, Connection);
myCommand.Parameters.AddWithValue("@Date", Date);
myCommand.Parameters.AddWithValue("@Class", Class);
myCommand.Parameters.AddWithValue("@Team", Team);
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
myDataReader.Read();
if (myDataReader[0].ToString() != "0")
{
IsReserved = true;
}
}
if (IsReserved)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('本時段您指定的傳情歌手已被他人選歌，請重新選擇...');window.location='/songlist';</script>");
//Response.Redirect("/songlist");
return;
}
//strSQL = @"SELECT SongCount from [SongTotal] WHERE Day = @Date and Class = @Class";
//myCommand = new SqlCommand(strSQL, Connection);
//myCommand.Parameters.AddWithValue("@Date", Date);
//myCommand.Parameters.AddWithValue("@Class", Class);
//using(SqlDataReader myDataReader = myCommand.ExecuteReader())
//{
// myDataReader.Read();
// if(Convert.ToInt32(myDataReader[0].ToString()) >= 10) IsFull = true;
//}
//if(IsFull)
//{
// ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('本時段可選歌數已滿，請重新選擇...');window.location='/songlist';</script>");
// //Response.Redirect("/songlist");
// return;
//}
else if (!IsFull && !IsReserved)
{
strSQL = "INSERT INTO Reserve ([TID],[Day],[Class],[SID],[Place],[ClassName],[GeneralLesson],[Name],[DepartGrade],[Phone],[Email],[SentName],[SentDepartGrade],[SentPhone],[SentEmail],[PayDay],[SpecialRequest],[Remark]) VALUES (@TID, @Day, @Class, @SID, @Place, @ClassName, @GeneralLesson, @Name, @DepartGrade, @Phone, @Email, @SentName, @SentDepartGrade,@SentPhone,@SentEmail,@PayDay,@SpecialRequest,@Remark)";
myCommand = new SqlCommand(strSQL, Connection);
myCommand.Parameters.AddWithValue("@TID", Team);
myCommand.Parameters.AddWithValue("@Day", Date);
myCommand.Parameters.AddWithValue("@Class", Class);
myCommand.Parameters.AddWithValue("@SID", Song);
myCommand.Parameters.AddWithValue("@Place", Place);
myCommand.Parameters.AddWithValue("@ClassName", ClassName);
myCommand.Parameters.AddWithValue("@GeneralLesson", GeneralLesson);
myCommand.Parameters.AddWithValue("@Name", Name);
myCommand.Parameters.AddWithValue("@DepartGrade", DepartGrade);
myCommand.Parameters.AddWithValue("@Phone", Phone);
myCommand.Parameters.AddWithValue("@Email", Email);
myCommand.Parameters.AddWithValue("@SentName", SentName);
myCommand.Parameters.AddWithValue("@SentDepartGrade", SentDepartGrade);
myCommand.Parameters.AddWithValue("@SentPhone", SentPhone);
myCommand.Parameters.AddWithValue("@SentEmail", SentEmail);
myCommand.Parameters.AddWithValue("@PayDay", PayDay);
myCommand.Parameters.AddWithValue("@SpecialRequest", SpecialRequest);
myCommand.Parameters.AddWithValue("@Remark", Remark);
//String strSQL2 = @"UPDATE [SongTotal] SET SongCount+=1 WHERE Day = @Date and Class = @Class";
//SqlCommand myCommand2 = new SqlCommand(strSQL2, Connection);
//myCommand2.Parameters.AddWithValue("@Date", Date);
//myCommand2.Parameters.AddWithValue("@Class", Class);
try
{
myCommand.ExecuteNonQuery();
//myCommand2.ExecuteNonQuery();
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('資料庫錯誤');window.location='/songlist';", true);
//Response.Redirect("/songlist");
return;
}
AlertMsg.Text = "<script language='javascript'>Congrats();</script>";
this.Page.Controls.Add(AlertMsg);
}
}
catch
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('連線錯誤');window.location='/songlist';", true);
//Response.Redirect("/songlist");
return;
}
finally
{
Connection.Close();
}
}
public IResult FormTest(FormContent content)
{
Console.WriteLine($"Received form content of number of parameters: {content.Form.Count}");
return(new Redirect("http://www.google.com"));
}
public JsonResult UpdateFormContent(FormContent formContents)
{
context.FormContentCollection.Save(formContents);
return(Json("Update Successfull", JsonRequestBehavior.AllowGet));
}
internal HtmlGenerator(FormContent formContent, string outDir)
: base(formContent, outDir)
{
FieldBase.Init();
}
