private void SaveData()
{
MST_SHIFT_DAL _dalMST_SHIFT = null;
Hashtable _htParameters = null;
int iNextID = 0;
try
{
_dalMST_SHIFT = new MST_SHIFT_DAL();
_htParameters = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(pnlBody.Controls, _htParameters);
Utility.ApplyDefaultProp(_htParameters);
if (Request.Params["action"] == "add")
{
_dalMST_SHIFT.Insert(_htParameters, ref iNextID);
}
else
{
_dalMST_SHIFT.Update(_htParameters);
iNextID = Int32.Parse(lblID.Text);
}
Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "mstshiftdtl.aspx?action=edt&id=" + iNextID.ToString());
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null);
}
}
protected void gvwList_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "Edit":
Response.Redirect("mstshiftdtl.aspx?action=edt&id=" + e.CommandArgument);
break;
case "Delete":
MST_SHIFT_DAL _dalMST_SHIFT = null;
Hashtable _htParameters = null;
try
{
_dalMST_SHIFT = new MST_SHIFT_DAL();
_htParameters = new Hashtable();
_htParameters["p_ID"] = e.CommandArgument.ToString();
_dalMST_SHIFT.Delete(_htParameters);
this.BindGrid();
Response.Redirect("mstshiftlist.aspx");
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
break;
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
//isEditMode = !isEditMode;
//BindData();
//btnCancel.Visible = false;
//btnsimpan.Text = "Edit";
if (isAdddMode)
{
MST_SHIFT_DAL _dalMST_SHIFT = new MST_SHIFT_DAL();
Hashtable _htParameters = new Hashtable();
_htParameters["p_Year"] = ddlYear.SelectedValue.ToString();
_htParameters["p_Month"] = ddlMonth.SelectedValue.ToString();
_htParameters["p_KODE_UNIT_KERJA"] = ddlUnitKerja.SelectedValue.ToString();
_htParameters["p_STATUS_SHIFT"] = ddlStatus.SelectedValue.ToString();
dtx = _dalMST_SHIFT.GetRows_HR_SHIFT(_htParameters);
isAdddMode = false;
//btnAdd.Visible = true;
}
else
{
isEditMode = !isEditMode;
}
//BindData();
BindData(dtx);
btnCancel.Visible = false;
btnsimpan.Text = "Edit";
}
private void BindGrid()
{
MST_SHIFT_DAL _dalMST_SHIFT = null;
Hashtable _htParameters = null;
try
{
_dalMST_SHIFT = new MST_SHIFT_DAL();
_htParameters = new Hashtable();
_htParameters["p_keywords"] = txtSearch.Text;
gvwList.DataSource = _dalMST_SHIFT.GetRows(_htParameters);
gvwList.DataBind();
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
}
}
private void LoadData()
{
MST_SHIFT_DAL _dalMST_SHIFT = null;
Hashtable _htParameters = null;
try
{
//System.Diagnostics.Debugger.Break();
_dalMST_SHIFT = new MST_SHIFT_DAL();
_htParameters = new Hashtable();
_htParameters["p_ID"] = Request.Params["id"];
DataTable _dt = _dalMST_SHIFT.GetRow(_htParameters);
MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]);
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
}
}
//void SaveData()
//{
// for (int i = 0; i < dtx.Rows.Count; i++)
// {
// for (int j = 0; j < dtx.Columns.Count; j++)
// {
// dtx.Rows[i][j] = ((TextBox)GridView.Rows[i].Cells[j].Controls[0]).Text;
// }
// }
// bindGrid();
//}
private void BindGridSearch()
{
DataTable dt = new DataTable();
MST_SHIFT_DAL _dalMST_SHIFT = null;
Hashtable _htParameters = null;
try
{
_dalMST_SHIFT = new MST_SHIFT_DAL();
_htParameters = new Hashtable();
_htParameters["p_Year"] = ddlYear.SelectedValue.ToString();
_htParameters["p_Month"] = ddlMonth.SelectedValue.ToString();
_htParameters["p_KODE_UNIT_KERJA"] = ddlUnitKerja.SelectedValue.ToString();
_htParameters["p_STATUS_SHIFT"] = ddlStatus.SelectedValue.ToString();
dt = _dalMST_SHIFT.GetRows_HR_SHIFT(_htParameters);
if (dt.Columns.Count < 10)
{
//bindGrid();
bindGrid2(dt);
isRows = "0"; //insert
}
else
{
//BindData();
BindData(dt);
isRows = "1"; //update
}
}
catch (Exception ex)
{
Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
}
}
public void InstantiateIn(System.Web.UI.Control Container)
{
switch (ItemType)
{
case ListItemType.EditItem:
if (InfoType == "Button")
{
ImageButton update_button = new ImageButton();
update_button.ID = "update_button";
update_button.CommandName = "Update";
update_button.ToolTip = "Update";
update_button.OnClientClick = "return confirm('Are you sure to update the record?')";
Container.Controls.Add(update_button);
// Similarly, add a button for Cancel
}
else if (InfoType == "Textbox")
// if other key and non key fields then bind textboxes with texts
{
TextBox field_txtbox = new TextBox();
field_txtbox.ID = FieldName;
field_txtbox.Text = String.Empty;
field_txtbox.ReadOnly = true;
// if to update then bind the textboxes with coressponding field texts
//otherwise for insert no need to bind it with text
//if ((int)new Page().Session["InsertFlag"] == 0)
field_txtbox.DataBinding += new EventHandler(OnDataBinding);
Container.Controls.Add(field_txtbox);
}
else if (InfoType == "Label")
{
Label field_txtbox = new Label();
field_txtbox.ID = FieldName;
field_txtbox.Text = String.Empty;
field_txtbox.DataBinding += new EventHandler(OnDataBinding);
Container.Controls.Add(field_txtbox);
}
else if (InfoType == "DropDownPeg")
{
HR_PEGAWAI_DAL _dalHR_PEGAWAI_DAL = new HR_PEGAWAI_DAL();
Hashtable _htParameters = new Hashtable();
DropDownList ddlPeg = new DropDownList();
ddlPeg.ID = FieldName;
_htParameters["p_keywords"] = "";
ddlPeg.DataSource = _dalHR_PEGAWAI_DAL.GetRows(_htParameters);
ddlPeg.DataValueField = "NIK";
ddlPeg.DataTextField = "NAMA";
ddlPeg.DataBind();
Container.Controls.Add(ddlPeg);
}
else
{
MST_SHIFT_DAL _dalMST_SHIFT = new MST_SHIFT_DAL();
Hashtable _htParameters = new Hashtable();
DropDownList ddlTgl = new DropDownList();
ddlTgl.ID = FieldName;
_htParameters["p_keywords"] = "";
ddlTgl.DataSource = _dalMST_SHIFT.GetRowsKode(_htParameters);
ddlTgl.DataValueField = "KODE";
ddlTgl.DataTextField = "KODE";
ddlTgl.DataBind();
ddlTgl.DataBinding += new EventHandler(OnDataBindingDDL);
Container.Controls.Add(ddlTgl);
}
break;
case ListItemType.Item:
if (InfoType == "Label")
{
Label field_txtbox = new Label();
field_txtbox.ID = FieldName;
field_txtbox.Text = String.Empty;
field_txtbox.DataBinding += new EventHandler(OnDataBinding);
Container.Controls.Add(field_txtbox);
}
break;
}
}
protected void btnsimpan_Click(object sender, EventArgs e)
{
isEditMode = !isEditMode;
if (isEditMode)
{
btnsimpan.Text = "Save";
btnCancel.Visible = true;
GridView.Columns.Clear();
string nik = dtx.Rows[0][0].ToString();
if (nik == "")
{
//template insert --> NIK
for (int i = 0; i < dtx.Columns.Count - (dtx.Columns.Count - 1); i++)
{
TemplateField ItemTmpField = new TemplateField();
ItemTmpField.HeaderText = dtx.Columns[i].ColumnName;
ItemTmpField.ItemTemplate = new DynamicallyTemplatedGridViewHandler(ListItemType.EditItem, dtx.Columns[i].ColumnName, "Textbox");
GridView.Columns.Add(ItemTmpField);
}
//template insert --> NAMA
for (int i = 1; i <= dtx.Columns.Count - (dtx.Columns.Count - 1); i++)
{
TemplateField ItemTmpField = new TemplateField();
ItemTmpField.HeaderText = dtx.Columns[i].ColumnName;
ItemTmpField.ItemTemplate = new DynamicallyTemplatedGridViewHandler(ListItemType.EditItem, dtx.Columns[i].ColumnName, "Textbox"); //DropDownPeg
GridView.Columns.Add(ItemTmpField);
}
}
else
{
//template update --> tgl
for (int i = 0; i <= dtx.Columns.Count - (dtx.Columns.Count - 1); i++)
{
TemplateField ItemTmpField = new TemplateField();
ItemTmpField.HeaderText = dtx.Columns[i].ColumnName;
ItemTmpField.ItemTemplate = new DynamicallyTemplatedGridViewHandler(ListItemType.EditItem, dtx.Columns[i].ColumnName, "Textbox");
GridView.Columns.Add(ItemTmpField);
}
}
for (int j = 2; j <= dtx.Columns.Count - 1; j++)
{
TemplateField ItemTmpField = new TemplateField(); //dt.Columns[4].DataType.Name ;dtx.Columns[j].ColumnName.Substring(0, 2)
ItemTmpField.HeaderText = dtx.Columns[j].ColumnName;
ItemTmpField.ItemTemplate = new DynamicallyTemplatedGridViewHandler(ListItemType.EditItem, dtx.Columns[j].ColumnName, "DropDown");
GridView.Columns.Add(ItemTmpField);
}
GridView.DataSource = dtx;
GridView.DataBind();
}
else
{
btnsimpan.Text = "Edit";
btnCancel.Visible = false;
//awal
List <string> keys = Request.Form.AllKeys.Where(key => key.Contains("GridView")).ToList();
if (keys.Count > 0)
{
string[] ctrls = Request.Form.ToString().Split('&');
string ctrlValue = "";
string ctrlName = "";
string tgl = "";
string nik = "";
for (int i = 0; i < ctrls.Length; i++)
{
if (ctrls[i].Contains("GridView"))
{
ctrlName = ctrls[i].Split('=')[0];
ctrlValue = ctrls[i].Split('=')[1];
//Decode the Value
ctrlValue = Server.UrlDecode(ctrlValue);
ctrlName = Server.UrlDecode(ctrlName);
tgl = ctrlName.Substring(ctrlName.Length - 2, 2);
if (!IsNumeric(tgl))
{
if (ctrlName.Substring(ctrlName.Length - 3, 3) == "NIK")
{
nik = ctrlValue;
}
if (ctrlName.Substring(ctrlName.Length - 4, 4) == "NAMA")
{
if (nik == "")
{
nik = ctrlValue;
}
}
continue;
}
MST_SHIFT_DAL _dalMST_SHIFT = new MST_SHIFT_DAL();
Hashtable _htParameters = new Hashtable();
_htParameters["p_KODE_REFF_SHIFT"] = ctrlValue;
_htParameters["p_NIK"] = nik;
_htParameters["p_KODE_UNIT_KERJA"] = ddlUnitKerja.SelectedValue;
_htParameters["p_TANGGAL_SHIFT"] = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue + "-" + tgl;
_htParameters["p_STATUS_SHIFT"] = ddlStatus.SelectedValue;
Utility.ApplyDefaultProp(_htParameters);
//if (isRows == "0")
//{
// //insert
// _dalMST_SHIFT.InsertHR_Shift(_htParameters);
//}
//else if (isRows == "1")
//{
// //update
// _dalMST_SHIFT.UpdateHR_Shift(_htParameters);
//}
//else
//{
// //update-insert
// _dalMST_SHIFT.UpdateInsertHR_Shift(_htParameters);
//}
_dalMST_SHIFT.UpdateInsertHR_Shift(_htParameters);
}
}
}
//akhir
BindGridSearch();
btnsimpan.Visible = false;
//btnAdd.Visible = true;
isAdddMode = false;
//List<string> colors = new List<string>();
//colors.Add("Red");
//colors.Add("Blue");
//colors.Add("Green");
//foreach (string color in colors) //for (int i = 0; i < colors.Count; i++)
//{
//}
//foreach (GridViewRow row in GridView.Rows)
//{
// for (int i = 0; i < GridView.Columns.Count; i++)
// {
// String header = GridView.Columns[i].HeaderText;
// String cellText = row.Cells[i].Text;
// }
//}
//int x = 2;
//foreach (GridViewRow row in GridView.Rows)
//{
// DropDownList FCCrrr = new DropDownList();
// FCCrrr = (DropDownList)row.FindControl("DropDown" + x);
// string abc = FCCrrr.SelectedValue;
// x++;
//}
}
}
