public void BindData()
{
ChuteDAO chutedao = new ChuteDAO();
DataSet dataSet = chutedao.Search_chute();
RadGrid1.DataSource = dataSet.Tables[0];
}
public void BindData(Int32 area_ID)
{
ChuteDAO chmgr = new ChuteDAO();
DataSet dataSet = chmgr.Chutes_In_Area(area_ID);
RadGrid1.DataSource = dataSet.Tables[0];
foreach (DataRow row in dataSet.Tables[0].Rows)
{
rowcount++;
}
}
protected void Btn_stack_Click(object sender, System.EventArgs e)
{
ChuteDAO chmgr = new ChuteDAO();
UserActivity setclass = new UserActivity();
ActivityLogDAO actlog = new ActivityLogDAO();
Int32 stack_seq = 0;
string displayname = User.Identity.Name;
try
{
stack_seq = Int32.Parse(tb_stack.Text.ToString());
if (stack_seq != 0)
{
decimal upd_status = chmgr.Manage_stack(areaID, stack_seq, displayname);
if (upd_status == 0)
{
HandleError("Stacks and Trolleys Created successfully", 0);
}
else if (upd_status == -1)
{
HandleError("Trolley detach Failed", 1);
}
else
{
HandleError("Error Occurred", 1);
}
}
else
{
HandleError("Invalid Stack Sequence", 1);
}
Initialize_stack();
}
catch (Exception ex2)
{
HandleError(ex2.Message, 1);
Initialize_save();
}
BindData(areaID);
RadGrid1.Rebind();
}
void Initialize_save()
{
Btn_chute.Enabled = false;
Btn_stack.Visible = true;
lbl_stack.Visible = true;
tb_stack.Visible = true;
RequiredFieldValidator1.Visible = true;
tb_stack.Text = string.Empty;
ChuteDAO chutedao = new ChuteDAO();
if (chutedao.CheckStack(areaID.ToString()))
{
Btn_stack.Enabled = false;
}
else
{
Btn_stack.Enabled = true;
}
}
protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
string ch_label = null;
Int32 ch_status_int;
Int32 ch_type_int;
string enb_ind_str;
string int_ind_str;
decimal area_id_dec;
string displayname = User.Identity.Name;
Int32 trolley_type_int;
decimal Chuteid = decimal.Parse(editedItem.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["chute_id"].ToString());
RadTextBox chlabel = (RadTextBox)editedItem.FindControl("ch_label_TextBox");
ch_label = chlabel.Text.ToString();
//RadComboBox chstatus = (RadComboBox)editedItem.FindControl("ch_status_RadComboBox");
RadComboBox chtype = (RadComboBox)editedItem.FindControl("ch_type_RadComboBox");
RadComboBox enbind = (RadComboBox)editedItem.FindControl("ch_enb_ind_RadComboBox");
//RadComboBox intind = (RadComboBox)editedItem.FindControl("ch_int_ind_RadComboBox");
RadComboBox areaid = (RadComboBox)editedItem.FindControl("ch_area_RadComboBox");
RadComboBox trolleytype = (RadComboBox)editedItem.FindControl("trolleytype_RadComboBox");
//ch_status_int = Int32.Parse(chstatus.SelectedValue);
ch_status_int = 3;
ch_type_int = Int32.Parse(chtype.SelectedValue);
enb_ind_str = enbind.SelectedValue.ToString();
//int_ind_str = intind.SelectedValue.ToString();
area_id_dec = decimal.Parse(areaid.SelectedValue);
if (ch_type_int == 2)//multi chute
{
trolley_type_int = Int32.Parse(trolleytype.SelectedValue);
}
else
{
trolley_type_int = 0;
}
ChuteDAO chuteinsert = new ChuteDAO();
try
{
decimal chuteid = chuteinsert.Update_Chute(Chuteid,
ch_label,
ch_status_int,
ch_type_int,
enb_ind_str,
area_id_dec,
displayname,
trolley_type_int);
if (chuteid == 0)
{
// display error
string err_msg = "Error while updating Chute ID: " + Chuteid;
HandleError(err_msg, 1);
}
else if (chuteid == -1)
{
string err_msg = "Area in Use. Cannot update Chute";
HandleError(err_msg, 1);
}
else
{
HandleError("Chute Updated", 0);
}
}
catch (Exception ex_upd)
{
string err = ex_upd.Message;
HandleError(err, 1);
}
BindData();
}
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem dataItem = (GridDataItem)e.Item;
decimal Chuteid = decimal.Parse(dataItem.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["chute_id"].ToString());
Label chtype = (Label)dataItem.FindControl("chtypid");
Int32 ch_type_int = Int32.Parse(chtype.Text);
//
// for the edit image
if (Chuteid >= 10000 && ch_type_int == 2)
{
dataItem["EditCommandColumn"].Controls[0].Visible = true;
}
else
{
dataItem["EditCommandColumn"].Controls[0].Visible = false;
}
}
if (e.Item is GridEditableItem && (e.Item as GridEditableItem).IsInEditMode)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
GridEditFormInsertItem insert = e.Item as GridEditFormInsertItem;
ChuteDAO chute_dao = new ChuteDAO();
// chute type drop down
DataSet ds_chutetype = new DataSet();
ds_chutetype = chute_dao.GetChuteType();
RadComboBox chtype = (RadComboBox)editedItem
.FindControl("ch_type_RadComboBox");
chtype.DataSource = ds_chutetype.Tables["CT"];
chtype.DataTextField = "type_short_name";
chtype.DataValueField = "chute_type_id";
chtype.DataBind();
chtype.Items.Insert(0, new RadComboBoxItem("", "0"));
// chute status drop down
/*
* DataSet ds_chstatus = new DataSet();
* ds_chstatus = chute_dao.GetChuteStatus();
*
* RadComboBox chstatus = (RadComboBox)editedItem
* .FindControl("ch_status_RadComboBox");
*
* chstatus.DataSource = ds_chstatus.Tables["CS"];
* chstatus.DataTextField = "status_short_name";
* chstatus.DataValueField = "chute_status_id";
* chstatus.DataBind();
* chstatus.Items.Insert(0, new RadComboBoxItem("", "0"));*/
// Enable indicator drop down
DataSet ds_enbind = new DataSet();
ds_enbind = chute_dao.GetEnableInd();
RadComboBox enbind = (RadComboBox)editedItem
.FindControl("ch_enb_ind_RadComboBox");
enbind.DataSource = ds_enbind.Tables["EI"];
enbind.DataTextField = "ch_enable_desc";
enbind.DataValueField = "ch_enable_code";
enbind.DataBind();
enbind.Items.Insert(0, new RadComboBoxItem("", "0"));
// International indicator drop down
//DataSet ds_intind = new DataSet();
//ds_intind = chute_dao.GetIntInd();
//RadComboBox intind = (RadComboBox)editedItem
// .FindControl("ch_int_ind_RadComboBox");
//intind.DataSource = ds_intind.Tables["II"];
//intind.DataTextField = "ch_int_desc";
//intind.DataValueField = "ch_int_code";
//intind.DataBind();
//intind.Items.Insert(0, new RadComboBoxItem("", "0"));
// Area drop down
DataSet ds_area = new DataSet();
ds_area = chute_dao.GetArea();
RadComboBox area = (RadComboBox)editedItem
.FindControl("ch_area_RadComboBox");
area.DataSource = ds_area.Tables["AR"];
area.DataTextField = "area_desc";
area.DataValueField = "aread_id";
area.DataBind();
area.Items.Insert(0, new RadComboBoxItem("", "0"));
TrolleyDAO trolleydao = new TrolleyDAO();
DataSet trolleyCodes = new DataSet();
trolleyCodes = trolleydao.GetCodesByType();
RadComboBox trolleytype = (RadComboBox)editedItem
.FindControl("trolleytype_RadComboBox");
trolleytype.DataSource = trolleyCodes.Tables["TT"];
trolleytype.DataTextField = "type_short_name";
trolleytype.DataValueField = "type_id";
trolleytype.DataBind();
trolleytype.Items.Insert(0, new RadComboBoxItem("", "0"));
trolleytype.Visible = true;
//RadComboBox trolleytype = (RadComboBox)editedItem
// .FindControl("trolleytype_RadComboBox");
//trolleytype.Visible = false;
//RequiredFieldValidator RequiredFieldValidator6 = (RequiredFieldValidator)editedItem
// .FindControl("RequiredFieldValidator6");
//RequiredFieldValidator6.Enabled = false;
if (e.Item.ItemIndex != -1)
{
Int32 ChuteID = Int32.Parse(
editedItem
.OwnerTableView
.DataKeyValues[e.Item.ItemIndex]["chute_id"]
.ToString());
DataSet ds_chutedtls = new DataSet();
ds_chutedtls = chute_dao.Get_chuteclass(ChuteID);
DataTable dt_chutedtls = ds_chutedtls.Tables[0];
Int32 ch_type = 0;
Int32 tr_type = 0;
Int32 area_id = 0;
string label = null;
string enable = null;
string international = null;
foreach (DataRow row in dt_chutedtls.Rows)
{
ch_type = Int32.Parse(row["chutetyp_id"].ToString());
tr_type = Int32.Parse(row["trtyp_id"].ToString());
enable = row["enb_ind"].ToString();
international = row["int_ind"].ToString();
area_id = Int32.Parse(row["area_id"].ToString());
label = row["chlabel"].ToString();
}
RadTextBox ch_label = (RadTextBox)editedItem.FindControl("ch_label_TextBox");
ch_label.Text = label;
chtype.SelectedValue = ch_type.ToString();
trolleytype.SelectedValue = tr_type.ToString();
area.SelectedValue = area_id.ToString();
//intind.SelectedValue = enable;
enbind.SelectedValue = international;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Initialize();
string areaidstr = Request.QueryString["Area_id"].ToString();
if (areaidstr != null)
{
areaID = Int32.Parse(areaidstr);
}
ChuteDAO chmgr = new ChuteDAO();
string area_status = chmgr.Check_area(areaID);
//if (area_status == "T")
//{
// RadGrid1.Enabled = false;
// Btn_chute.Enabled = false;
// lblArea.Text = " Area "+ areaID + " is in Use.";
// lblArea.ForeColor = Color.Blue;
//}
//else
//{
// RadGrid1.Enabled = true;
// Btn_chute.Enabled = true;
// lblArea.Text = "Chutes for Area ID: " + areaID;
// lblArea.ForeColor = Color.Blue;
//}
this.BindData(areaID);
if (rowcount > 0)
{
if (area_status == "T")
{
RadGrid1.Enabled = false;
Btn_chute.Enabled = false;
lblArea.Text = " Area " + areaID + " is in Use.";
lblArea.ForeColor = Color.Blue;
}
else
{
RadGrid1.Enabled = true;
Btn_chute.Enabled = true;
lblArea.Text = "Chutes for Area ID: " + areaID;
lblArea.ForeColor = Color.Blue;
}
}
else
{
Btn_chute.Enabled = false;
lblArea.Text = "No Chutes exist for Area ID: " + areaID;
lblArea.ForeColor = Color.Blue;
}
}
catch (Exception ex1)
{
HandleError(ex1.Message, 1);
}
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
ChuteDAO chmgr = new ChuteDAO();
UserActivity setclass = new UserActivity();
ActivityLogDAO actlog = new ActivityLogDAO();
string displayname = User.Identity.Name;
// Create new DataTable and DataSource objects.
DataTable dt_seq = new DataTable();
// Declare DataColumn and DataRow variables.
DataColumn dc_seq;
DataRow dr_seq;
// Create new DataColumn, set DataType, ColumnName and add to DataTable.
dc_seq = new DataColumn();
dc_seq.DataType = System.Type.GetType("System.Int32");
dc_seq.ColumnName = "chute_id";
dt_seq.Columns.Add(dc_seq);
// Create second column.
dc_seq = new DataColumn();
dc_seq.DataType = System.Type.GetType("System.Int32");
dc_seq.ColumnName = "chute_seq";
dt_seq.Columns.Add(dc_seq);
try
{
foreach (GridItem item in RadGrid1.MasterTableView.Items)
{
if (item is GridEditableItem)
{
GridEditableItem editableItem = item as GridDataItem;
string chuteid_str = editableItem.OwnerTableView.DataKeyValues[item.ItemIndex]["chute_id"].ToString();
Int32 chuteid = Int32.Parse(chuteid_str);
Label ch_typ_lab = (Label)editableItem.FindControl("ch_type_lab");
Int32 ch_type_id = Int32.Parse(ch_typ_lab.Text);
if (ch_type_id == 2)
{
RadTextBox ch_seq_tb = (RadTextBox)editableItem.FindControl("ch_seq_TextBox");
Int32 ch_seq_id = Int32.Parse(ch_seq_tb.Text);
// Create new DataRow objects and add to DataTable.
dr_seq = dt_seq.NewRow();
dr_seq["chute_id"] = chuteid;
dr_seq["chute_seq"] = ch_seq_id;
dt_seq.Rows.Add(dr_seq);
}
}
}
dt_seq.DefaultView.Sort = "chute_seq";
dt_seq = dt_seq.DefaultView.ToTable();
Int32 realseq = 1;
foreach (DataRow row in dt_seq.Rows)
{
string id_str = row["chute_id"].ToString();
Int32 id = Int32.Parse(id_str);
decimal Chute_id = chmgr.Update_Chute_seq(id, realseq, displayname);
realseq++;
}
HandleError("Updated Chute Sequence Successfully", 0);
Initialize_save();
}
catch (Exception ex)
{
// activity logging
HandleError(ex.Message, 1);
}
BindData(areaID);
RadGrid1.Rebind();
}
