public WorkEntity Read(int agreementID) { Parameters = new List<SqlParameter>(); Parameters.Add(new SqlParameter("@AgreementTypeID", agreementID)); WorkEntity entity = null; SqlDataReader reader = null; try { Parameters.Add(new SqlParameter("@Action", "R")); reader = ExecDataReader(DBCommands.WorkTable); if (reader.Read()) { entity = new WorkEntity(); entity.WorkID =reader["WorkID"].ToInt32(); entity.GovernmentMarketingServices = reader["GovernmentMarketingServices"].ToStr(); entity.Lobbying = reader["Lobbying"].ToStr(); entity.NonEmpSalesRepresentation = reader["NonEmpSalesRepresentation"].ToStr(); entity.ServiceDescription = reader["ServiceDescription"].ToStr(); entity.ServicesProvided = reader["ServicesProvided"].ToStr(); entity.QuoteDocName = reader["QuoteDocName"].ToStr(); entity.QuoteDocUniqueName = reader["QuoteDocUniqueName"].ToStr(); } } finally { if (reader != null) { reader.Close(); reader.Dispose(); } } return entity; }
public int Insert(WorkEntity entity) { Parameters = new List<SqlParameter>(); Parameters.Add(new SqlParameter("@WorkID", entity.WorkID)); Parameters.Add(new SqlParameter("@AgreementTypeID", entity.AgreementTypeID)); Parameters.Add(new SqlParameter("@ServicesProvided", entity.ServicesProvided)); Parameters.Add(new SqlParameter("@ServiceDescription", entity.ServiceDescription)); Parameters.Add(new SqlParameter("@GovernmentMarketingServices", entity.GovernmentMarketingServices)); Parameters.Add(new SqlParameter("@Lobbying", entity.Lobbying)); Parameters.Add(new SqlParameter("@NonEmpSalesRepresentation", entity.NonEmpSalesRepresentation)); Parameters.Add(new SqlParameter("@QuoteDocUniqueName", entity.QuoteDocUniqueName)); Parameters.Add(new SqlParameter("@QuoteDocName", entity.QuoteDocName)); object id = null; if (entity.WorkID == 0) { Parameters.Add(new SqlParameter("@Action", "C")); id = ExecuteScalar(DBCommands.WorkTable); } else { Parameters.Add(new SqlParameter("@Action", "U")); ExecCommand(DBCommands.WorkTable); id = entity.WorkID; } return Convert.ToInt32(id); }
public int Insert(WorkEntity entity) { WorkDao workDao = new WorkDao(); return workDao.Insert(entity); }
private int SaveData(string action) { WorkEntity entity = new WorkEntity(); int agreementID = SessionManager.AgreementTypeID; entity.AgreementTypeID = agreementID; if (hdnWorkID.Value != string.Empty) { entity.WorkID = Convert.ToInt32(hdnWorkID.Value); } entity.ServicesProvided = rdoServicesProvided.SelectedValue; entity.GovernmentMarketingServices = rdoGovernmentMarketingServices.SelectedValue; entity.ServiceDescription = txtServiceDescription.Text.Trim(); entity.Lobbying = rdoLobbying.SelectedValue; entity.NonEmpSalesRepresentation = rdoNonEmpSalesRepresentation.SelectedValue; bool isFileSaved = upload(); //hdnWorkID.Value = Convert.ToString(entity.WorkID); string fileName = lblFileName.Text; string uniqueFileName = hdnFilePath.Value; entity.QuoteDocName = fileName; entity.QuoteDocUniqueName = uniqueFileName; //if (isFileSaved) //{ if (SessionManager.AgreementType == "R" || fileName != string.Empty || action == "S") { WorkBI work = new WorkBI(); int workID = work.Insert(entity); return workID; } //} return 0; }