protected void ctlServiceTeamForm_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
short serviceTeamId = Convert.ToInt16(ctlServiceTeamForm.DataKey.Value);
TextBox ctlServiceTeamCode = (TextBox)ctlServiceTeamForm.FindControl("ctlServiceTeamCode");
TextBox ctlDescription = (TextBox)ctlServiceTeamForm.FindControl("ctlDescription");
CheckBox ctlActiveChk = (CheckBox)ctlServiceTeamForm.FindControl("ctlActiveChk");
DbServiceTeam serviceTeam = DbServiceTeamService.FindByIdentity(serviceTeamId);
serviceTeam.ServiceTeamCode = ctlServiceTeamCode.Text;
serviceTeam.Description = ctlDescription.Text;
serviceTeam.Active = ctlActiveChk.Checked;
serviceTeam.CreBy = UserAccount.UserID;
serviceTeam.CreDate = DateTime.Now;
serviceTeam.UpdBy = UserAccount.UserID;
serviceTeam.UpdDate = DateTime.Now;
serviceTeam.UpdPgm = ProgramCode;
try
{
DbServiceTeamService.UpdateServiceTeam(serviceTeam);
ctlServiceTeamGrid.DataCountAndBind();
ctlServiceTeamForm.ChangeMode(FormViewMode.ReadOnly);
CloseServiceTeamPopUp();
}
catch (ServiceValidationException ex)
{
ValidationErrors.MergeErrors(ex.ValidationErrors);
}
}
protected void ctlLocationLookup_OnObjectLookUpReturn(object sender, ObjectLookUpReturnArgs e)
{
IList <DbLocation> locationList = (IList <DbLocation>)e.ObjectReturn;
IList <DbServiceTeamLocation> serviceTeamLocationList = new List <DbServiceTeamLocation>();
foreach (DbLocation location in locationList)
{
Location locate = new Location();
locate.LocationID = location.LocationID;
DbServiceTeam serviceTeam = ScgDbQueryProvider.DbServiceTeamQuery.FindByIdentity(Convert.ToInt64(ctlServiceTeamIDHidden.Value));
DbServiceTeamLocation serviceTeamLocation = GetServiceTeamLocation(serviceTeam, locate);
serviceTeamLocationList.Add(serviceTeamLocation);
}
if (serviceTeamLocationList.Count > 0)
{
try
{
DbServiceTeamLocationService.AddServiceTeamLocationList(serviceTeamLocationList);
ctlLocationGrid.DataCountAndBind();
}
catch (ServiceValidationException ex)
{
ValidationErrors.MergeErrors(ex.ValidationErrors);
}
}
ctlUpdatePanelLocationGrid.Update();
}
public int RequestCount_ctlLocationGrid()
{
DbServiceTeam serviceTeam = GetServiceTeamForLocationGrid();
int count = ScgDbQueryProvider.DbServiceTeamLocationQuery.CountServiceTeamLocationByServiceTeamID(serviceTeam);
return(count);
}
public DbServiceTeam GetServiceTeamCriteria()
{
DbServiceTeam serviceTeam = new DbServiceTeam();
serviceTeam.ServiceTeamCode = ctlServiceTeamCodeCri.Text;
serviceTeam.Description = ctlDescriptionCri.Text;
return(serviceTeam);
}
public int RequestCount()
{
DbServiceTeam serviceTeam = GetServiceTeamCriteria();
int count = ScgDbQueryProvider.DbServiceTeamQuery.CountServiceTeamByCriteria(serviceTeam);
return(count);
}
protected void ctlServiceTeamGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("ServiceTeamEdit"))
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
short serviceTeamId = Convert.ToInt16(ctlServiceTeamGrid.DataKeys[rowIndex].Value);
ctlServiceTeamForm.PageIndex = (ctlServiceTeamGrid.PageIndex * ctlServiceTeamGrid.PageSize) + rowIndex;
ctlServiceTeamForm.ChangeMode(FormViewMode.Edit);
IList <DbServiceTeam> serviceTeamList = new List <DbServiceTeam>();
DbServiceTeam serviceTeam = DbServiceTeamService.FindByIdentity(serviceTeamId);
serviceTeamList.Add(serviceTeam);
ctlServiceTeamForm.DataSource = serviceTeamList;
ctlServiceTeamForm.DataBind();
ctlUpdatePanelServiceTeamForm.Update();
ctlServiceTeamModalPopupExtender.Show();
}
if (e.CommandName.Equals("ServiceTeamDelete"))
{
try
{
int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
long serviceTeamId = UIHelper.ParseLong(ctlServiceTeamGrid.DataKeys[rowIndex].Value.ToString());
DbServiceTeam serviceTeam = ScgDbQueryProvider.DbServiceTeamQuery.FindByIdentity(serviceTeamId);
DbServiceTeamService.Delete(serviceTeam);
}
catch (Exception ex)
{
if (((System.Data.SqlClient.SqlException)(ex.GetBaseException())).Number == 547)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertInUseData",
"alert('This data is now in use.');", true);
ctlServiceTeamGrid.DataCountAndBind();
}
}
ctlServiceTeamGrid.DataCountAndBind();
ctlUpdatePanelServiceTeamGridview.Update();
}
if (e.CommandName.Equals("LocationEdit"))
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
ctlServiceTeamGrid.SelectedIndex = rowIndex;
long serviceTeamId = UIHelper.ParseShort(ctlServiceTeamGrid.DataKeys[rowIndex].Value.ToString());
ctlServiceTeamIDHidden.Value = serviceTeamId.ToString();
ctlLocationGrid.DataCountAndBind();
lblLocationHeader.Visible = true;
ctlLocationGrid.Visible = true;
ctlLocationTools.Visible = true;
ctlAddLocation.Visible = true;
ctlCloseLocation.Visible = true;
ctlUpdatePanelServiceTeamGridview.Update();
ctlUpdatePanelLocationGrid.Update();
}
}
private DbServiceTeamLocation GetServiceTeamLocation(DbServiceTeam serviceTeam, Location location)
{
DbServiceTeamLocation serviceTeamLocation = new DbServiceTeamLocation();
serviceTeamLocation.ServiceTeamID = new DbServiceTeam(serviceTeam.ServiceTeamID);
serviceTeamLocation.LocationID = new DbLocation(location.LocationID.Value);
serviceTeamLocation.Active = true;
serviceTeamLocation.CreBy = UserAccount.UserID;
serviceTeamLocation.CreDate = DateTime.Now;
serviceTeamLocation.UpdBy = UserAccount.UserID;
serviceTeamLocation.UpdDate = DateTime.Now;
serviceTeamLocation.UpdPgm = ProgramCode;
return(serviceTeamLocation);
}
protected void ctlServiceTeamForm_DataBound(object sender, EventArgs e)
{
if (ctlServiceTeamForm.CurrentMode != FormViewMode.ReadOnly)
{
TextBox ctlServiceTeamCode = (TextBox)ctlServiceTeamForm.FindControl("ctlServiceTeamCode");
ctlServiceTeamCode.Focus();
CheckBox ctlActiveCheck = (CheckBox)ctlServiceTeamForm.FindControl("ctlActiveChk");
if (ctlServiceTeamForm.CurrentMode == FormViewMode.Edit)
{
short serviceTeamID = UIHelper.ParseShort(ctlServiceTeamForm.DataKey.Value.ToString());
DbServiceTeam serviceTeam = DbServiceTeamService.FindByIdentity(serviceTeamID);
}
if (ctlServiceTeamForm.CurrentMode == FormViewMode.Insert)
{
ctlActiveCheck.Checked = true;
}
}
}
public IList <ServiceTeamLocationResult> GetServiceTeamLocationList(DbServiceTeam serviceTeam, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindByCriteria <ServiceTeamLocationResult>(ScgDbQueryProvider.DbServiceTeamLocationQuery, "FindServiceTeamLocationByServiceTeamID", new object[] { serviceTeam, false, sortExpression }));
}
public int CountServiceTeamLocationByServiceTeamID(DbServiceTeam serviceTeam)
{
return(NHibernateQueryHelper.CountByCriteria(ScgDbQueryProvider.DbServiceTeamLocationQuery, "FindServiceTeamLocationByServiceTeamID", new object[] { serviceTeam, true, string.Empty }));
}
public ISQLQuery FindServiceTeamLocationByServiceTeamID(DbServiceTeam serviceTeam, bool isCount, string sortExpression)
{
StringBuilder sqlBuilder = new StringBuilder();
if (!isCount)
{
sqlBuilder.Append(" SELECT ");
sqlBuilder.Append(" sl.ServiceTeamLocationID as ServiceTeamLocationID,");
sqlBuilder.Append(" sl.ServiceTeamID as ServiceTeamID,");
sqlBuilder.Append(" sl.LocationID as LocationID,");
sqlBuilder.Append(" l.LocationCode as LocationCode,");
sqlBuilder.Append(" c.CompanyCode as CompanyCode,");
sqlBuilder.Append(" c.CompanyName as CompanyName,");
sqlBuilder.Append(" l.Description as Description,");
sqlBuilder.Append(" sl.Active as Active");
sqlBuilder.Append("");
sqlBuilder.Append(" FROM DbServiceTeamLocation sl LEFT OUTER JOIN DbLocation l ON sl.LocationID = l.LocationID ");
sqlBuilder.Append(" LEFT OUTER JOIN DbCompany c ON l.CompanyID = c.CompanyID ");
sqlBuilder.Append(" WHERE sl.ServiceTeamID = :ServiceTeamID ");
if (string.IsNullOrEmpty(sortExpression))
{
sqlBuilder.AppendLine(" ORDER BY c.CompanyName, l.Description, sl.Active ");
}
else
{
sqlBuilder.AppendLine(string.Format(" ORDER BY {0}", sortExpression));
}
}
else
{
sqlBuilder.Append(" SELECT COUNT(sl.ServiceTeamLocationID) AS ServiceTeamLocationCount ");
sqlBuilder.Append(" FROM DbServiceTeamLocation sl LEFT OUTER JOIN DbLocation l ON sl.LocationID = l.LocationID ");
sqlBuilder.Append(" LEFT OUTER JOIN DbCompany c ON l.CompanyID = c.CompanyID ");
sqlBuilder.Append(" WHERE sl.ServiceTeamID = :ServiceTeamID ");
}
ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString());
QueryParameterBuilder queryParameterBuilder = new QueryParameterBuilder();
queryParameterBuilder.AddParameterData("ServiceTeamID", typeof(long), serviceTeam.ServiceTeamID);
queryParameterBuilder.FillParameters(query);
if (!isCount)
{
query.AddScalar("ServiceTeamLocationID", NHibernateUtil.Int64);
query.AddScalar("ServiceTeamID", NHibernateUtil.Int64);
query.AddScalar("LocationID", NHibernateUtil.Int64);
query.AddScalar("LocationCode", NHibernateUtil.String);
query.AddScalar("CompanyCode", NHibernateUtil.String);
query.AddScalar("CompanyName", NHibernateUtil.String);
query.AddScalar("Description", NHibernateUtil.String);
query.AddScalar("Active", NHibernateUtil.Boolean);
query.SetResultTransformer(Transformers.AliasToBean(typeof(ServiceTeamLocationResult)));
}
else
{
query.AddScalar("ServiceTeamLocationCount", NHibernateUtil.Int32);
query.UniqueResult();
}
return(query);
}
public DbServiceTeam GetServiceTeamForLocationGrid()
{
DbServiceTeam serviceTeam = ScgDbQueryProvider.DbServiceTeamQuery.FindByIdentity(Convert.ToInt64(ctlServiceTeamIDHidden.Value));
return(serviceTeam);
}
public Object RequestData_ctlLocationGrid(int startRow, int pageSize, string sortExpression)
{
DbServiceTeam serviceTeam = GetServiceTeamForLocationGrid();
return(ScgDbQueryProvider.DbServiceTeamLocationQuery.GetServiceTeamLocationList(serviceTeam, startRow, pageSize, sortExpression));
}
public Object RequestData(int startRow, int pageSize, string sortExpression)
{
DbServiceTeam serviceTeam = GetServiceTeamCriteria();
return(ScgDbQueryProvider.DbServiceTeamQuery.GetServiceTeamList(serviceTeam, startRow, pageSize, sortExpression));
}
