protected void Page_Load(object sender, EventArgs e)
{
string CamID = Session["Cam_ID"].ToString();
string ShowGA;
ShowGA = "SELECT Activity_ID, Activity_Name, Activity_StartDate, Activity_EndDate, Activity_Place, Activity_Province, Activity_Status,CAMP_ID FROM Activities WHERE Activity_ID = '" + CamID + "';";
// ShowGA = "select * from Activities where Activity_ID=" + CamID;
DataTable dt = dbconn.QueryExecuteScalar(ShowGA);
lblID.Text = dt.Rows[0]["Activity_ID"].ToString();
txtName.Text = dt.Rows[0]["Activity_Name"].ToString();
string s = dt.Rows[0]["Activity_StartDate"].ToString();
bdpStartDate.SelectedValue = Convert.ToDateTime(s).ToString("dd-MM-yyyy");
string endDate = dt.Rows[0]["Activity_EndDate"].ToString();
bdpEndDate.SelectedValue = Convert.ToDateTime(endDate).ToString("dd-MM-yyyy");
txtPlace.Text = dt.Rows[0]["Activity_Place"].ToString();
ddlProvince.SelectedValue = dt.Rows[0]["Activity_Province"].ToString();
lblStatus.Text = dt.Rows[0]["Activity_Status"].ToString();
ddlCAMP.SelectedValue = dt.Rows[0]["CAMP_ID"].ToString();
dbconn.Close();
}
private void RunID()
{
string findmax = "SELECT MAX(JobID) As MAXID FROM JobOrders;";
DataTable dt = dbconn.QueryExecuteScalar(findmax);
int CurYear = DateTime.Now.Year;
string NewID = "";
try
{
string DBYear = dt.Rows[0]["MAXID"].ToString().Substring(3, 4);
int DBID = Convert.ToInt32(dt.Rows[0]["MAXID"].ToString().Substring(7, 4));
if (Convert.ToInt32(DBYear) < CurYear)
{
NewID = "JO-" + Convert.ToString(CurYear) + "0001";
LblJobID.Text = NewID;
}
else if (Convert.ToInt32(DBYear) == CurYear)
{
int CurID = Convert.ToInt32(dt.Rows[0]["MAXID"].ToString().Substring(3, 8));
int AddNewID = Convert.ToInt32(CurID) + 1;
NewID = "JO-" + AddNewID.ToString();
LblJobID.Text = NewID;
}
}
catch
{
NewID = "JO-" + Convert.ToString(CurYear) + "0001";
LblJobID.Text = NewID;
}
dbconn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
string RawID = Session["RawID"].ToString();
string PRID = Session["PRID"].ToString();
string findPR = "SELECT * FROM PR WHERE PRID = '" + PRID + "';";
DataTable dt = dbconn.QueryExecuteScalar(findPR);
lblPRNo.Text = dt.Rows[0]["PRID"].ToString();
lblPrintDate.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");
lblDelDate.Text = Convert.ToDateTime(dt.Rows[0]["PRDelDate"]).ToString("dd/MM/yyyy");
lblJobID.Text = dt.Rows[0]["JobID"].ToString();
lblNetTotal.Text = dt.Rows[0]["NetMatPrice"].ToString();
lblTax.Text = dt.Rows[0]["VAT"].ToString();
lblTotal.Text = dt.Rows[0]["MatPrice"].ToString();
Label15.Text = dt.Rows[0]["CurrencyUnit"].ToString();
Label16.Text = Label15.Text;
Label17.Text = Label15.Text;
string findSup = "SELECT * FROM Suppliers WHERE SupID = " + dt.Rows[0]["SupID"].ToString() + ";";
DataTable dtSup = dbconn.QueryExecuteScalar(findSup);
lblSupName.Text = dtSup.Rows[0]["SupName"].ToString();
lblSupAdd.Text = dtSup.Rows[0]["SupAdd"].ToString();
lblSupTel.Text = dtSup.Rows[0]["SupTel"].ToString();
lblFax.Text = dtSup.Rows[0]["SupFax"].ToString();
lblSupEmail.Text = dtSup.Rows[0]["SupEmail"].ToString();
string findItemOrder = "SELECT dbo.ContactSuppliers.RawID, dbo.ContactSuppliers.ContactSupCost, dbo.RawMaterials.RawName, dbo.ContactSuppliers.RawUnit, dbo.ContactSuppliers.CurrencyUnit, dbo.ContactSuppliers.UnitPrice, dbo.ContactSuppliers.RawQty FROM dbo.ContactSuppliers INNER JOIN dbo.PR ON dbo.ContactSuppliers.ContactSupID = dbo.PR.ContactSupID INNER JOIN dbo.RawMaterials ON dbo.ContactSuppliers.RawID = dbo.RawMaterials.RawID WHERE (dbo.ContactSuppliers.ContactSupID = '" + dt.Rows[0]["ContactSupID"].ToString() + "') AND (dbo.ContactSuppliers.SelectSup = 'Yes') AND (dbo.ContactSuppliers.JobID = '" + lblJobID.Text + "' AND dbo.ContactSuppliers.RawID = '" + RawID + "');";
DataTable dtItem = dbconn.QueryExecuteScalar(findItemOrder);
GridView1.DataSource = dtItem;
GridView1.DataBind();
dbconn.Close();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
String FindJobOrder = "Select * from JobOrders where JobID Like '%" + txtFindJO.Text + "%' or CusName like '%" + txtFindJO.Text + "%' and JobStatus = 'กำลังจัดซื้อวัตถุดิบ';";
DataTable dt = dbconn.QueryExecuteScalar(FindJobOrder);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string search = "SELECT CM_ID, CM_Name, MT_Name, CT_Name FROM CampaignerMedias, MediaTypes, ChannalTypes WHERE CampaignerMedias.CT_ID = ChannalTypes.CT_ID AND CampaignerMedias.MT_ID = MediaTypes.MT_ID AND (CM_ID like '%" + TextBox1.Text + "%' OR CM_Name like '%" + TextBox1.Text + "%');";
DataTable dt = dbconn.QueryExecuteScalar(search);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
PanelSearchResult.Visible = true;
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
PanelSearchResult.Visible = true;
string findCAMP = "SELECT Activity_ID,Activity_Place,Activity_Province, Activity_Name,Activity_StartDate, Activity_EndDate, Activity_Status, CAMP_Name FROM Activities, CampaignTypes WHERE (Activity_Type = 'Campaign') AND Activities.CAMP_ID = CampaignTypes.CAMP_ID AND (Activity_Status = 'Starting')AND ((Activity_ID LIKE '%" + txtSearch.Text + "%') OR (Activity_Name LIKE '%" + txtSearch.Text + "%'));";
DataTable dt = dbconn.QueryExecuteScalar(findCAMP);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string findPR = "SELECT dbo.PerchaseRequests.PCRID, dbo.PerchaseRequests.PCRQty, dbo.PerchaseRequests.PCRDate, dbo.PerchaseRequests.PCRStatus, dbo.PerchaseRequests.RawID, dbo.PerchaseRequests.JobItemID, dbo.PerchaseRequests.JobID, dbo.PerchaseRequests.PCRReason, dbo.PerchaseRequests.PCRUnit, dbo.RawMaterials.RawName FROM dbo.PerchaseRequests INNER JOIN dbo.RawMaterials ON dbo.PerchaseRequests.RawID COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.RawMaterials.RawID WHERE (dbo.PerchaseRequests.PCRID LIKE '%" + TextBox1.Text + "%') ;";
DataTable dt = dbconn.QueryExecuteScalar(findPR);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
Panel2.Visible = true;
Panel1.Visible = false;
}
protected void btnSearch_Click(object sender, ImageClickEventArgs e)
{
string findIDName;
findIDName = "SELECT Activity_ID, Activity_Name, Activity_StartDate, Activity_EndDate, Activity_Status, Activity_Type,Activities.TTY_ID,TTY_Name,Activities.TT_ID, TT_Name FROM Activities, TrainingTypes,TrainingTeams WHERE Activity_Type = 'Training' AND Activities.TT_ID = TrainingTeams.TT_ID AND Activity_Status = 'Starting' AND Activities.TTY_ID = TrainingTypes.TTY_ID AND (Activity_ID like'%" + txtSearch.Text + "%' Or Activity_Name like'%" + txtSearch.Text + "%');";
DataTable dt = dbconn.QueryExecuteScalar(findIDName);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
PanelSearchResult.Visible = true;
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string findIDName;
findIDName = "SELECT Activity_ID, Activity_Name, Activity_StartDate, Activity_EndDate, Activity_Status,Activity_Place,Activity_Province, Activity_Type FROM Activities WHERE Activity_Status = 'Starting' AND Activity_Type = 'General Activity' AND (Activity_ID like'%" + txtSearch.Text + "%' Or Activity_Name like'%" + txtSearch.Text + "%');";
DataTable dt = dbconn.QueryExecuteScalar(findIDName);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
PanelSearchResult.Visible = true;
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
PanelSearchResult.Visible = true;
PanelSearch.Visible = true;
string findIDName;
findIDName = "select RawID, RawName, RawMaterials.RawUnitID, RawUnitName, RawMaterials.RawTypeID, RawTypeName from RawMaterials, RawMatTypes, RawUnit where RawMaterials.RawTypeID = RawMatTypes.RawTypeID AND (RawMaterials.RawUnitID = RawUnit.RawUnitID) AND (RawID LIKE '%" + TxtIDName.Text + "%' or RawName LIKE '%" + TxtIDName.Text + "%');";
DataTable dt = dbconn.QueryExecuteScalar(findIDName);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
}
protected void BtnSearchAll_Click(object sender, EventArgs e)
{
PanelSearch.Visible = true;
PanelResult.Visible = true;
string findall;
findall = "Select CusID, CusName, CusAdd from Customers order by CusID";
DataTable dt = dbconn.QueryExecuteScalar(findall);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string insertRaw = "insert into RawMaterials(RawName,RawTypeID,RawUnitID) values ('" + TxtRawName.Text + "','" + DrdType.SelectedValue + "', '" + DrdUnit.SelectedValue + "');";
dbconn.QueryExecuteScalar(insertRaw);
dbconn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string CurrentFileName = FileUpload1.FileName;
string CurrentPath = Server.MapPath("~/TrainingSourceDownload/");
if (TextBox1.Text != "")
{
try
{
if (FileUpload1.HasFile)
{
CurrentPath += CurrentFileName;
FileUpload1.SaveAs(CurrentPath);
string insert = "INSERT INTO LessonKnowledges(LL_ID,K_Name,K_File) VALUES (" + DropDownList3.SelectedValue + ",'" + TextBox1.Text + "','" + CurrentFileName + "');";
dbconn.QueryExecuteScalar(insert);
GridView1.DataBind();
TextBox1.Text = "";
MessageBox.Show("Knowledge for Lesson has been successfully add");
}
dbconn.Close();
}
catch
{
MessageBox.Show("Please select file to upload");
}
}
else
{
MessageBox.Show("Plese enter file name before confirm submitting");
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
PanelSearchResult.Visible = true;
PanelDetail.Visible = false;
PanelUpdateResult.Visible = false;
string findIDName;
findIDName = "SELECT SupID, SupName, SupAdd from Suppliers where (SupID like'%" + TxtIDName.Text + "%' or SupName like '%" + TxtIDName.Text + "%') order by SupID";
DataTable dt = dbconn.QueryExecuteScalar(findIDName);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
string ID = Session["Activity_ID"].ToString();
string findMail = "Select V_Email FROM Volunteer,VolunteerJoinActivities WHERE VolunteerJoinActivities.V_ID = Volunteer.V_ID AND Activity_ID = " + ID + " AND V_Email IS NOT NULL;";
DataTable dt = dbconn.QueryExecuteScalar(findMail);
int row = dt.Rows.Count;
string Email;
for (int i = 1; i <= row - 1; i++)
{
Email = dt.Rows[i]["V_Email"].ToString() + ",";
txtTo.Text += Email;
}
string Detail = "SELECT VolunteerJoinActivities.Activity_ID, Activity_Name, Activity_StartDate, Activity_EndDate, Activity_Place, Activity_Province FROM VolunteerJoinActivities, Activities WHERE VolunteerJoinActivities.Activity_ID = Activities.Activity_ID AND Activities.Activity_ID = " + ID + ";";
DataTable dtAct = dbconn.QueryExecuteScalar(Detail);
string ActID = dtAct.Rows[0]["Activity_ID"].ToString();
string ActName = dtAct.Rows[0]["Activity_Name"].ToString();
string Start = Convert.ToDateTime(dtAct.Rows[0]["Activity_StartDate"]).ToString("dd/MM/yyyy");
string End = Convert.ToDateTime(dtAct.Rows[0]["Activity_EndDate"]).ToString("dd/MM/yyyy");
string Place = dtAct.Rows[0]["Activity_Place"].ToString();
string Province = dtAct.Rows[0]["Activity_Province"].ToString();
txtMessage.Text = "Dear Volunteers," + Environment.NewLine + " We would like to invite you to join Activity " + ActName + Environment.NewLine + Environment.NewLine + "Place : " + Place + "," + Province + Environment.NewLine + "Start From " + Start + "To" + End + Environment.NewLine + " If you are interest and able to join us, Please contact us at 023334444 or [email protected]." + Environment.NewLine + Environment.NewLine + "Best Regard," + Environment.NewLine + "Volunteer Management Team" + Environment.NewLine + Environment.NewLine + Environment.NewLine + Environment.NewLine + "เรียนอาสาสมัคร" + Environment.NewLine + "ทางองค์กรขอเชิญชวนท่านเข้าร่วมกิจกรรม " + ActName + " สถานที่ " + Place + Province + " ในวันที่ " + Start + " ถึงวันที่ " + End + Environment.NewLine + " หากท่านมีความสนในที่จะเข้าร่วมกิจกรรมและสามารถเข้าร่วมได้ กรุณาตอบกลับที่อีเมล์ [email protected] หรือที่ 023334444" + Environment.NewLine + "ทางองค์กรขอขอบพรุะคุณท่านอย่างสูง ที่ให้การตอบรับและสนับสนุนองค์กรด้วยดีเสมอมา" + Environment.NewLine + Environment.NewLine + "ด้วยความนับถือ" + Environment.NewLine + "งานอาสาสมัคร";
txtSubject.Text = "เชิญอาสาสมัครเข้าร่วมกิจกรรม G Volunteer invite you to join Activity";
dbconn.Close();
}
protected void BtnSaveSup_Click(object sender, EventArgs e)
{
string insertSup = "insert into Suppliers(SupName,SupContact,SupAdd,SupTel,SupFax,SupEmail) values ('" + TxtSupName.Text + "','" + TxtSupContact.Text + "', '" + TxtSupAdd.Text + "','" + TxtSupPhone.Text + "','" + TxtSupFax.Text + "', '" + TxtSupEmail.Text + "');";
dbconn.QueryExecuteScalar(insertSup);
dbconn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string check = "SELECT MT_ID, CT_ID FROM MediaChannels WHERE MT_ID = " + DropDownList2.SelectedValue + " AND CT_ID = " + DropDownList1.SelectedValue + ";";
DataTable dt = dbconn.QueryExecuteScalar(check);
if (dt.Rows.Count == 1)
{
MessageBox.Show("Sorry you have selected Channal for this Media already !!");
}
else
{
string insert = "INSERT INTO MediaChannels (MT_ID,CT_ID) Values (" + DropDownList2.SelectedValue + "," + DropDownList1.SelectedValue + ");";
dbconn.QueryExecuteScalar(insert);
GridView1.DataBind();
MessageBox.Show("Channal for Media has been added successfully");
Panel1.Visible = false;
}
}
catch
{
string insert = "INSERT INTO MediaChannels (MT_ID,CT_ID) Values (" + DropDownList2.SelectedValue + "," + DropDownList1.SelectedValue + ");";
dbconn.QueryExecuteScalar(insert);
GridView1.DataBind();
MessageBox.Show("Channal for Media has been added successfully");
Panel1.Visible = false;
}
dbconn.Close();
}
protected void Confirm_Click(object sender, EventArgs e)
{
string Skills;
Skills = "INSERT INTO Skills (Skill_Name, ST_ID) VALUES ('" + TextBox1.Text + "','" + DropDownList3.SelectedValue + "');";
dbconn.QueryExecuteScalar(Skills);
dbconn.Close();
}
protected void Button4_Click(object sender, EventArgs e)
{
string sqlinsertemp;
sqlinsertemp = "insert into employees(EmpID,EmpName,EmpCardID,EmpAdd,EmpTel,EmpStatus,EmpRoleID)values('" + TxtEmpID.Text + "','" + TxtName.Text + "','" + TxtEmpID.Text + "','" + TxtAddress.Text + "','" + TxtPhone.Text + "','Active','" + DdlRole.SelectedValue + "');";
dbconn.QueryExecuteScalar(sqlinsertemp);
dbconn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string TrainID = Session["Train_ID"].ToString();
int Amount;
if (!Int32.TryParse(txtAmount.Text, out Amount))
{
MessageBox.Show("Please insert Amount of SubBudget in correct format!");
}
string insertSB;
insertSB = "insert into SubBudgets ( SB_Amount, Budget_ID, Activity_ID) VALUES (" + Amount + ",'" + ddlBudget.SelectedValue + "'," + TrainID + ");";
dbconn.QueryExecuteScalar(insertSB);
dbconn.Close();
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
string SqlInsertCT;
SqlInsertCT = "insert into JoinedAreas (JA_Name) Values ('" + TextBox1.Text + "');";
dbconn.QueryExecuteScalar(SqlInsertCT);
dbconn.Close();
GridView1.DataBind();
}
protected void Confirm_Click(object sender, EventArgs e)
{
string SqlInsertCT;
SqlInsertCT = "insert into Interests (Interest_Name) Values ('" + TextBox1.Text + "');";
dbconn.QueryExecuteScalar(SqlInsertCT);
dbconn.Close();
GridView1.DataBind();
}
protected void Confirm_Click(object sender, EventArgs e)
{
string insert;
insert = "Insert INTO SkillItems (SI_Name, Skill_ID) VALUES ('" + TextBox1.Text + "','" + DropDownList4.SelectedValue + "');";
dbconn.QueryExecuteScalar(insert);
dbconn.Close();
GridView1.DataBind();
}
protected void Confirm_Click(object sender, EventArgs e)
{
string NewBudget = "insert into Budgets (Budget_Name, BT_ID) Values ('" + TextBox1.Text + "','" + DropDownList2.SelectedValue + "');";
dbconn.QueryExecuteScalar(NewBudget);
dbconn.Close();
// Response.Redirect("~/Master Data MGT/Budget.aspx");
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
string SqlInsertET;
SqlInsertET = "insert into EquipmentTypes (ET_Name) Values ('" + TextBox1.Text + "');";
dbconn.QueryExecuteScalar(SqlInsertET);
dbconn.Close();
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
dt = new DataTable();
MakeDataTable();
}
else
{
dt = (DataTable)ViewState["DataTable"];
}
ViewState["DataTable"] = dt;
string FindMaXID = "SELECT MAX(V_ID) As MAXID FROM Volunteer; ";
DataTable dtNew = dbconn.QueryExecuteScalar(FindMaXID);
int max = Convert.ToInt32(dtNew.Rows[0]["MAXID"]);
lblID.Text = (max + 1).ToString();
dbconn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string INSERT = "Insert INTO LevelLessons(Level_ID,LL_Name) VALUES (" + DropDownList2.SelectedValue + ",'" + TextBox1.Text + "');";
dbconn.QueryExecuteScalar(INSERT);
Panel1.Visible = false;
GridView1.DataBind();
MessageBox.Show("Lesson for Level has been added successfully");
dbconn.Close();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string findV = "SELECT V_ID, V_Name, V_Lastname,V_EngName,V_EngLastName,V_Status FROM Volunteer WHERE V_ID like '%" + TextBox1.Text + "%' or V_Name like '%" + TextBox1.Text + "%' ;";
DataTable dt = dbconn.QueryExecuteScalar(findV);
GridView1.DataSource = dt;
GridView1.DataBind();
dbconn.Close();
PanelSearchResult.Visible = true;
}
protected void Button1_Click(object sender, EventArgs e)
{
string SqlInsertCT;
SqlInsertCT = "insert into ChannalTypes (CT_Name) Values ('" + TextBox1.Text + "');";
dbconn.QueryExecuteScalar(SqlInsertCT);
dbconn.Close();
GridView1.DataBind();
// Response.Redirect("~/Master Data MGT/Channel Type.aspx");
}
protected void BtnSaveCus_Click(object sender, EventArgs e)
{
string today = DateTime.Now.Date.ToString("yyyy-MM-dd");
string insertcus = "insert into Customers(CusID,CusName,CusAdd,CusTel,CusEmail,CusDate) values ('" + lblID.Text + "','" + TxtCusName.Text + "','" + TxtCusAdd.Text + "', '" + TxtCusTel.Text + "','" + TxtCusEmail.Text + "','" + today + "') ;";
dbconn.QueryExecuteScalar(insertcus);
dbconn.Close();
Response.Redirect("~/Master/CompleteSave.aspx");
}
