public List <MarketingR> GetAllCampaign() { string query = "SELECT * from campaign WHERE Budget=0 "; List <MarketingR> iList = new List <MarketingR>(); DatabaseConnection dc = new DatabaseConnection(); dc.ConnectWithDB(); SqlDataReader sdr = dc.GetData(query); while (sdr.Read()) { MarketingR i = new MarketingR(); i.CampaignId = Convert.ToInt32(sdr["CampaignId"]); i.CampaignName = sdr["CampaignName"].ToString(); i.Objective = sdr["Objective"].ToString(); i.Placement = sdr["Placement"].ToString(); i.EmployeeName = sdr["EmployeeName"].ToString(); i.LaunchDate = sdr["LaunchDate"].ToString(); i.EndDate = sdr["EndDate"].ToString(); i.RunningCost = Convert.ToDouble(sdr["RunningCost"]); i.Report = sdr["Report"].ToString(); i.Budget = Convert.ToDouble(sdr["Budget"]); i.Status = sdr["Status"].ToString(); iList.Add(i); } dc.CloseConnection(); return(iList); }
public bool UpdateBudget(MarketingR er) { AccountingRepository ar = new AccountingRepository(); if (ar.updateBalance(er.Budget)) { try { // UPDATE employee SET DepartmentName="sales" WHERE id="M102"; string query = "UPDATE campaign SET Budget =" + er.Budget + " WHERE CampaignId=" + er.CampaignId + " "; DatabaseConnection dc = new DatabaseConnection(); dc.ConnectWithDB(); int x = dc.ExecuteSQL(query); dc.CloseConnection(); return(true); } catch (Exception) { return(false); } } else { return(false); } }
// public List <MarketingR> GetCampaign(string CampaignId) { string query = "SELECT * from campaign WHERE CampaignId= '" + CampaignId + "'"; List <MarketingR> iList = new List <MarketingR>(); DatabaseConnection dc = new DatabaseConnection(); dc.ConnectWithDB(); SqlDataReader sdr = dc.GetData(query); while (sdr.Read()) { MarketingR i = new MarketingR(); i.CampaignName = sdr["CampaignName"].ToString(); i.Objective = sdr["Objective"].ToString(); i.Placement = sdr["Placement"].ToString(); i.EmployeeName = sdr["EmployeeId"].ToString(); i.LaunchDate = sdr["LaunchDate"].ToString(); i.EndDate = sdr["EndDate"].ToString(); //i.RunningCost = sdr["RunningCost"].ToString(); i.Report = sdr["Report"].ToString(); iList.Add(i); } dc.CloseConnection(); return(iList); }
// public List <MarketingR> searchCampaign(string text) { string query = "SELECT * from campaign WHERE CampaignId Like '%" + text + "%' or CampaignName like '%" + text + "%' or Objective like '%" + text + "%' or Placement like '%" + text + "%' or EmployeeName like '%" + text + "%' or LaunchDate like '%" + text + "%' or EndDate like '%" + text + "%' or RunningCost like '%" + text + "%' or Report like '%" + text + "%' "; List <MarketingR> iList = new List <MarketingR>(); DatabaseConnection dc = new DatabaseConnection(); dc.ConnectWithDB(); SqlDataReader sdr = dc.GetData(query); while (sdr.Read()) { MarketingR i = new MarketingR(); i.CampaignId = Convert.ToInt32(sdr["CampaignId"]); i.CampaignName = sdr["CampaignName"].ToString(); i.Objective = sdr["Objective"].ToString(); i.Placement = sdr["Placement"].ToString(); i.EmployeeName = sdr["EmployeeName"].ToString(); i.LaunchDate = sdr["LaunchDate"].ToString(); i.EndDate = sdr["EndDate"].ToString(); //i.RunningCost = sdr["RunningCost"].ToString(); i.Report = sdr["Report"].ToString(); i.Status = sdr["Status"].ToString(); iList.Add(i); } dc.CloseConnection(); return(iList); }
// public bool Update(MarketingR mk) { try { // string query = "UPDATE campaign SET CampaignName='" + mk.CampaignName + "',Objective='" + mk.Objective + "',Placement='" + mk.Placement + "',EmployeeName='" + mk.EmployeeName + "', LaunchDate='" + mk.LaunchDate + "',EndDate='" + mk.EndDate + "',RunningCost=" + mk.RunningCost + ",Status='" + mk.Status + "',Report='" + mk.Report + "',Budget= " + mk.Budget + "WHERE CampaignId=" + mk.CampaignId + " "; DatabaseConnection dc = new DatabaseConnection(); dc.ConnectWithDB(); int x = dc.ExecuteSQL(query); dc.CloseConnection(); return(true); } catch (Exception) { return(false); } }
public bool Insert(MarketingR mk) { try { // INSERT INTO campaign(CampaignID,CampaignName,Objective,Placement,EmployeeID,LaunchDate,EndDate) //VALUES ("y180_FBIB","Fastest bike bangladesh RoadShow","300 feet","M102",10-12-2018 to 12-12-2018) string query = " INSERT into campaign VALUES ('" + mk.CampaignName + "','" + mk.Objective + "','" + mk.Placement + "','" + mk.EmployeeName + "','" + mk.LaunchDate + "','" + mk.EndDate + "','" + mk.RunningCost + "','" + mk.Report + "' ," + mk.Budget + ",'" + mk.Status + "' ) "; DatabaseConnection dc = new DatabaseConnection(); dc.ConnectWithDB(); int x = dc.ExecuteSQL(query); dc.CloseConnection(); return(true); } catch (Exception) { return(false); } }