protected override void ShowData(int ClientXProjectId) { oDetailButtonPanel.SetId = SetId; var data = new ClientXProjectDataModel(); data.ClientXProjectId = ClientXProjectId; var dt = ClientXProjectDataManager.GetDetails(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { var row = dt.Rows[0]; lblClientXProjectId.Text = Convert.ToString(row[ClientXProjectDataModel.DataColumns.ClientXProjectId]); lblClient.Text = Convert.ToString(row[ClientXProjectDataModel.DataColumns.Client]); lblProject.Text = Convert.ToString(row[ClientXProjectDataModel.DataColumns.Project]); oUpdateInfo.LoadText(dt.Rows[0]); oHistoryList.Setup((int)SystemEntity.ClientXProject, ClientXProjectId, "ClientXProject"); dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "ClientXProject"); } else { Clear(); } }
private static string Save(ClientXProjectDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.ClientXProjectInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.ClientXProjectUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, ClientXProjectDataModel.DataColumns.ClientXProjectId) + ", " + ToSQLParameter(data, ClientXProjectDataModel.DataColumns.ProjectId) + ", " + ToSQLParameter(data, ClientXProjectDataModel.DataColumns.ClientId); return(sql); }
private DataTable GetData(string name) { var data = new ClientXProjectDataModel(); var dt = ClientXProjectDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
public static DataTable Search(ClientXProjectDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
public static void Delete(ClientXProjectDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.ClientXProjectDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, ClientXProjectDataModel.DataColumns.ClientXProjectId); DBDML.RunSQL("ClientXProject.Delete", sql, DataStoreKey); }
public override int?Save(string action) { var data = new ClientXProjectDataModel(); data.ClientXProjectId = ClientXProjectId; data.ClientId = ClientId; data.ProjectId = ProjectId; if (action == "Insert") { ClientXProjectDataManager.Create(data, SessionVariables.RequestProfile); } else { ClientXProjectDataManager.Update(data, SessionVariables.RequestProfile); } // not correct ... when doing insert, we didn't get/change the value of ClientID ? return(data.ClientXProjectId); }
protected void btnDelete_Click(object sender, EventArgs e) { try { var deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new ClientXProjectDataModel(); data.ClientXProjectId = int.Parse(index); ClientXProjectDataManager.Delete(data, SessionVariables.RequestProfile); } AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)SystemEntity.ClientXProject, SessionVariables.RequestProfile); Response.Redirect(Page.GetRouteUrl("ClientXProjectEntityRoute", new { Action = "Default", SetId = true }), false); } catch (Exception ex) { Response.Write(ex.Message); } }
public void LoadData(int ClientXProjectId, bool showId) { var data = new ClientXProjectDataModel(); data.ClientXProjectId = ClientXProjectId; var oClientXProjectTable = ClientXProjectDataManager.GetDetails(data, SessionVariables.RequestProfile); if (oClientXProjectTable.Rows.Count == 1) { var row = oClientXProjectTable.Rows[0]; if (!showId) { txtClientXProjectId.Text = Convert.ToString(row[ClientXProjectDataModel.DataColumns.ClientXProjectId]); dynAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup((int)SystemEntity.ClientXProject, ClientXProjectId, "ClientXProject"); dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "ClientXProject"); } else { txtClientXProjectId.Text = String.Empty; } txtClientId.Text = Convert.ToString(row[ClientXProjectDataModel.DataColumns.ClientId]); txtProjectId.Text = Convert.ToString(row[ClientXProjectDataModel.DataColumns.ProjectId]); drpProjectList.SelectedValue = Convert.ToString(row[ClientXProjectDataModel.DataColumns.ProjectId]); drpClientList.SelectedValue = Convert.ToString(row[ClientXProjectDataModel.DataColumns.ClientId]); oUpdateInfo.LoadText(oClientXProjectTable.Rows[0]); } else { txtClientXProjectId.Text = String.Empty; txtProjectId.Text = String.Empty; txtClientId.Text = String.Empty; } }
public static List <ClientXProjectDataModel> GetEntityDetails(ClientXProjectDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.ClientXProjectSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , ClientXProjectId = dataQuery.ClientXProjectId , ClientId = dataQuery.ClientId , ProjectId = dataQuery.ProjectId }; List <ClientXProjectDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <ClientXProjectDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static void Update(ClientXProjectDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("ClientXProject.Update", sql, DataStoreKey); }
public static string ToSQLParameter(ClientXProjectDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ClientXProjectDataModel.DataColumns.ClientXProjectId: if (data.ClientXProjectId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ClientXProjectDataModel.DataColumns.ClientXProjectId, data.ClientXProjectId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ClientXProjectDataModel.DataColumns.ClientXProjectId); } break; case ClientXProjectDataModel.DataColumns.ClientId: if (data.ClientId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ClientXProjectDataModel.DataColumns.ClientId, data.ClientId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ClientXProjectDataModel.DataColumns.ClientId); } break; case ClientXProjectDataModel.DataColumns.ProjectId: if (data.ProjectId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ClientXProjectDataModel.DataColumns.ProjectId, data.ProjectId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ClientXProjectDataModel.DataColumns.ProjectId); } break; case ClientXProjectDataModel.DataColumns.Client: if (!string.IsNullOrEmpty(data.Client)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ClientXProjectDataModel.DataColumns.Client, data.Client); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ClientXProjectDataModel.DataColumns.Client); } break; case ClientXProjectDataModel.DataColumns.Project: if (!string.IsNullOrEmpty(data.Project)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ClientXProjectDataModel.DataColumns.Project, data.Project); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ClientXProjectDataModel.DataColumns.Project); } break; } return(returnValue); }
public static ClientXProjectDataModel GetDetails(ClientXProjectDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }