public void bindData()
{
JobOrderStatus status = new JobOrderStatus();
status.LoadAll();
GridViewStatus.DataSource = status.DefaultView;
GridViewStatus.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
JobOrderStatus status = new JobOrderStatus();
if (EditJobOrderStatus > 0)
{
status.LoadByPrimaryKey(EditJobOrderStatus);
}
else
{
status.AddNew();
}
status.JobOrderStatusName = txtStatusName.Text;
status.JobOrderStatusNameAr = txtStatusNameAr.Text;
status.StatusClass = dropDownStatusColor.Value;
status.Save();
ClearFields();
bindData();
panelStatusGrid.Visible = true;
panelStatusEdit.Visible = false;
}
protected void GridViewStatus_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "editStatus")
{
JobOrderStatus status = new JobOrderStatus();
status.LoadByPrimaryKey(int.Parse(e.CommandArgument.ToString()));
txtStatusName.Text = status.JobOrderStatusName;
txtStatusNameAr.Text = status.JobOrderStatusNameAr;
dropDownStatusColor.Value = status.StatusClass;
EditJobOrderStatus = int.Parse(e.CommandArgument.ToString());
panelStatusGrid.Visible = false;
panelStatusEdit.Visible = true;
}
else if (e.CommandName == "deleteStatus")
{
JobOrderStatus status = new JobOrderStatus();
status.LoadByPrimaryKey(int.Parse(e.CommandArgument.ToString()));
status.MarkAsDeleted();
status.Save();
bindData();
}
}
private void LoadData()
{
Clients clients = new Clients();
clients.LoadAll();
uiDropDownListClient.DataSource = clients.DefaultView;
uiDropDownListClient.DataTextField = Clients.ColumnNames.ClientName;
uiDropDownListClient.DataValueField = Clients.ColumnNames.ClientID;
uiDropDownListClient.DataBind();
JobOrderStatus statuses = new JobOrderStatus();
statuses.LoadAll();
uiDropDownListJOStatus.DataSource = statuses.DefaultView;
uiDropDownListJOStatus.DataTextField = JobOrderStatus.ColumnNames.JobOrderStatusNameAr;
uiDropDownListJOStatus.DataValueField = JobOrderStatus.ColumnNames.JobOrderStatusID;
uiDropDownListJOStatus.DataBind();
GeneralLookup digitalItem = new GeneralLookup ();
digitalItem.LoadByCategoryID(Category.DigitalPrintingType);
uiCheckBoxListDigitalItem.DataSource = digitalItem.DefaultView;
uiCheckBoxListDigitalItem.DataTextField = GeneralLookup.ColumnNames.Name;
uiCheckBoxListDigitalItem.DataValueField = GeneralLookup.ColumnNames.GeneralLookupID;
uiCheckBoxListDigitalItem.DataBind();
GeneralLookup serviceType = new GeneralLookup();
serviceType.LoadByCategoryID(Category.DigitalPrintingServiceType);
uiCheckBoxListServiceType.DataSource = serviceType.DefaultView;
uiCheckBoxListServiceType.DataTextField = GeneralLookup.ColumnNames.Name;
uiCheckBoxListServiceType.DataValueField = GeneralLookup.ColumnNames.GeneralLookupID;
uiCheckBoxListServiceType.DataBind();
GeneralLookup digitalPrintingSupplier = new GeneralLookup();
digitalPrintingSupplier.LoadByCategoryID(Category.DigitalPrintingSupplier);
uiDropDownListDigitalPrintingSupplier.DataSource = digitalPrintingSupplier.DefaultView;
uiDropDownListDigitalPrintingSupplier.DataTextField = GeneralLookup.ColumnNames.Name;
uiDropDownListDigitalPrintingSupplier.DataValueField = GeneralLookup.ColumnNames.GeneralLookupID;
uiDropDownListDigitalPrintingSupplier.DataBind();
GeneralLookup paperType = new GeneralLookup();
paperType.LoadByCategoryID(Category.OffsetPrintingPaperType);
uiRadioButtonListPaperType.DataSource = paperType.DefaultView;
uiRadioButtonListPaperType.DataTextField = GeneralLookup.ColumnNames.Name;
uiRadioButtonListPaperType.DataValueField = GeneralLookup.ColumnNames.GeneralLookupID;
uiRadioButtonListPaperType.DataBind();
GeneralLookup GSM = new GeneralLookup();
GSM.LoadByCategoryID(Category.OffsetPrintingGSM);
uiRadioButtonListGSM.DataSource = GSM.DefaultView;
uiRadioButtonListGSM.DataTextField = GeneralLookup.ColumnNames.Name;
uiRadioButtonListGSM.DataValueField = GeneralLookup.ColumnNames.GeneralLookupID;
uiRadioButtonListGSM.DataBind();
GeneralLookup offsetPrintHouse = new GeneralLookup();
offsetPrintHouse.LoadByCategoryID(Category.OffsetPrintingPrintHouse);
uiDropDownListOffsetPrintHouse.DataSource = offsetPrintHouse.DefaultView;
uiDropDownListOffsetPrintHouse.DataTextField = GeneralLookup.ColumnNames.Name;
uiDropDownListOffsetPrintHouse.DataValueField = GeneralLookup.ColumnNames.GeneralLookupID;
uiDropDownListOffsetPrintHouse.DataBind();
GeneralLookup finishBy = new GeneralLookup();
finishBy.LoadByCategoryID(Category.OffsetPrintingFinishingSupplier);
uiDropDownListOffsetPrintingFinishingBy.DataSource = finishBy.DefaultView;
uiDropDownListOffsetPrintingFinishingBy.DataTextField = GeneralLookup.ColumnNames.Name;
uiDropDownListOffsetPrintingFinishingBy.DataValueField = GeneralLookup.ColumnNames.GeneralLookupID;
uiDropDownListOffsetPrintingFinishingBy.DataBind();
GeneralLookup offsetFinishType = new GeneralLookup();
offsetFinishType.LoadByCategoryID(Category.OffsetPrintingFinishType);
uiCheckBoxListOffsetFinishType.DataSource = offsetFinishType.DefaultView;
uiCheckBoxListOffsetFinishType.DataTextField = GeneralLookup.ColumnNames.Name;
uiCheckBoxListOffsetFinishType.DataValueField = GeneralLookup.ColumnNames.GeneralLookupID;
uiCheckBoxListOffsetFinishType.DataBind();
}
public void GetJOStatuses()
{
JobOrderStatus statues = new JobOrderStatus();
statues.LoadAll();
List<Models.StatusModel> AllStatuses = statues.DefaultView.Table.AsEnumerable().Select(row =>
{
return new Models.StatusModel
{
StatusID = Convert.ToInt32(row[JobOrderStatus.ColumnNames.JobOrderStatusID].ToString()),
StatusName = row[JobOrderStatus.ColumnNames.JobOrderStatusName].ToString(),
StatusNameAr = row[JobOrderStatus.ColumnNames.JobOrderStatusNameAr].ToString(),
StatusClass = row[JobOrderStatus.ColumnNames.StatusClass].ToString()
};
}).ToList();
SetContentResult(AllStatuses);
//return _response;
}