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