protected void btnDelete_Click(object sender, EventArgs e)
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "DELETE FROM CIS.TransmittalDetails WHERE trancode='" + txtTransmittalCode.Text + "' AND schlcode=@schlcode";
cmd.Parameters.Add("@schlcode", SqlDbType.Char, 3);
cn.Open();
foreach (DataGridItem ditm in dgItems.Items)
{
HiddenField phdnItemStatus = (HiddenField)ditm.FindControl("hdnItemStatus");
HiddenField phdnSchlCode = (HiddenField)ditm.FindControl("hdnSchlCode");
CheckBox pchkDelete = (CheckBox)ditm.FindControl("chkDelete");
if (phdnItemStatus.Value == "0" && pchkDelete.Checked)
{
cmd.Parameters["@schlcode"].Value = phdnSchlCode.Value;
if (clsTransmittal.GetItemStatus(txtTransmittalCode.Text, phdnSchlCode.Value) == "0")
{
cmd.ExecuteNonQuery();
}
}
}
}
clsTransmittal transmittal = new clsTransmittal();
transmittal.TransmittalCode = txtTransmittalCode.Text;
dgItems.DataSource = transmittal.DSGItems().DefaultView;
dgItems.DataBind();
foreach (DataGridItem ditm in dgItems.Items)
{
CheckBox pchkDelete = (CheckBox)ditm.FindControl("chkDelete");
HiddenField phdnItemStatus = (HiddenField)ditm.FindControl("hdnItemStatus");
pchkDelete.Visible = (phdnItemStatus.Value == "0" ? true : false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
if (!Page.IsPostBack)
{
bool blnReadOnly = false;
DataTable tblItems = new DataTable("Items");
txtTransmittalCode.Text = Request.QueryString["trancode"];
txtGroupHeadName.Text = clsUsers.GetName(Request.Cookies["Speedo"]["UserName"]);
clsTransmittal transmittal = new clsTransmittal();
transmittal.TransmittalCode = txtTransmittalCode.Text;
transmittal.Fill();
hdnRequestor.Value = transmittal.UserName;
txtRequestor.Text = clsUsers.GetName(hdnRequestor.Value);
txtDateReq.Text = transmittal.DateRequested.ToString();
txtItemDesc.Text = transmittal.ItemDescription;
txtUnit.Text = transmittal.Unit;
txtRemarks.Text = transmittal.Remarks;
txtDispType.Text = transmittal.DispatchTypeDescription;
txtStat.Text = transmittal.StatusDescription;
if (transmittal.DispatchType == "H")
{
txtChargeTo.Text = clsRC.GetRCName(transmittal.ChargeTo);
}
else if (transmittal.DispatchType == "S")
{
txtChargeTo.Text = clsSchool.GetSchoolName(transmittal.ChargeTo);
}
hdnGroupHead.Value = transmittal.GroupHead;
txtGroupHeadRemarks.Text = transmittal.GroupHeadRemarks;
txtDateNeeded.Text = transmittal.DateNeeded.ToString();;
if (transmittal.GroupHeadStatus == "A" && (transmittal.ApproverStatus == "A" || transmittal.ApproverStatus == "D"))
{
hdnApprover.Value = transmittal.Approver;
txtApproverName.Text = clsUsers.GetName(transmittal.Approver);
txtApproverRemarks.Text = transmittal.ApproverRemarks;
}
else
{
trApprover.Visible = false;
trApproverRem.Visible = false;
}
blnReadOnly = (transmittal.GroupHeadStatus == "F" ? false : true);
dgItems.DataSource = transmittal.DSGItems().DefaultView;
dgItems.DataBind();
txtGroupHeadRemarks.ReadOnly = blnReadOnly;
divButtons.Visible = !blnReadOnly;
divButtons2.Visible = !blnReadOnly;
if (blnReadOnly)
{
txtGroupHeadRemarks.BackColor = System.Drawing.Color.FromName("#f0f8ff");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
if (!Page.IsPostBack)
{
DataTable tblItems = new DataTable("Items");
txtTransmittalCode.Text = Request.QueryString["trancode"];
txtEmployeeName.Text = clsUsers.GetName(Request.Cookies["Speedo"]["UserName"]);
clsTransmittal transmittal = new clsTransmittal();
transmittal.TransmittalCode = txtTransmittalCode.Text;
transmittal.Fill();
txtDateRequested.Text = transmittal.DateRequested.ToString();
txtItemDescription.Text = transmittal.ItemDescription;;
txtUnit.Text = transmittal.Unit;;
txtRemarks.Text = transmittal.Remarks;;
txtDispatchType.Text = transmittal.DispatchTypeDescription;
hdnStatus.Value = transmittal.Status;
txtStatus.Text = transmittal.StatusDescription;
if (transmittal.DispatchType == "H" || transmittal.DispatchType == "S")
{
if (transmittal.DispatchType == "H")
{
txtChargeTo.Text = clsRC.GetRCName(transmittal.ChargeTo);
}
else if (transmittal.DispatchType == "S")
{
txtChargeTo.Text = clsSchool.GetSchoolName(transmittal.ChargeTo);
}
txtGroupHeadName.Text = clsUsers.GetName(transmittal.GroupHead);
txtGroupHeadRemarks.Text = transmittal.GroupHeadRemarks;
txtDateNeeded.Text = transmittal.DateNeeded.ToString();
if (transmittal.GroupHeadStatus == "A" && transmittal.ApproverStatus == "P")
{
txtApproverName.Text = clsUsers.GetName(transmittal.Approver);
txtApproverRemarks.Text = transmittal.ApproverRemarks;
}
else
{
txtApproverName.Text = "";
txtApproverRemarks.Text = "";
}
trChargeTo.Visible = true;
trDateNeeded.Visible = true;
trGroupHead.Visible = true;
trGroupHeadRem.Visible = true;
trApproverName.Visible = true;
trApproverRemarks.Visible = true;
}
dgItems.DataSource = transmittal.DSGItems().DefaultView;
dgItems.DataBind();
if (hdnStatus.Value == "F" || hdnStatus.Value == "A")
{
divButtons.Visible = true;
}
else
{
divButtons.Visible = false;
}
if (hdnStatus.Value == "C" || hdnStatus.Value == "V")
{
btnDelete.Visible = false;
dgItems.Columns[3].Visible = false;
}
foreach (DataGridItem ditm in dgItems.Items)
{
CheckBox pchkDelete = (CheckBox)ditm.FindControl("chkDelete");
HiddenField phdnItemStatus = (HiddenField)ditm.FindControl("hdnItemStatus");
if (phdnItemStatus.Value == "0")
{
pchkDelete.Visible = true;
}
else
{
pchkDelete.Visible = false;
divButtons.Visible = false;
}
}
}
}