public Int64 SaveIssueDetail(IssueDetail id) { //string dbcs = "Data source=.;database=MantisDB;Integrated Security = SSPI"; InitializeConnectionString(); SqlConnection con = new SqlConnection(dbcs); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SaveIssueDetail"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@MantisId", id.MantisID)); cmd.Parameters.Add(new SqlParameter("@Slno", id.SLNO)); cmd.Parameters.Add(new SqlParameter("@Summary", id.Summary)); cmd.Parameters.Add(new SqlParameter("@AssingedBy", id.AssingedBy)); //cmd.Parameters.Add(new SqlParameter("@ReportDate", null)); cmd.Parameters.Add(new SqlParameter("@Description", id.Description)); SqlParameter parId = new SqlParameter(); parId.Direction = ParameterDirection.Output; parId.ParameterName = "@Id"; parId.DbType = DbType.Int64; cmd.Parameters.Add(parId); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return(Convert.ToInt64(parId.Value) > 0 ? Convert.ToInt64(parId.Value) : -1); }
public IEnumerable <IssueDetail> GetIssueDetails(long MantisId) { //string dbcs = "Data source=.;database=MantisDB;Integrated Security = SSPI"; InitializeConnectionString(); SqlConnection con = new SqlConnection(dbcs); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from IssueDetail where MantisId = " + MantisId + " order by SLNo"; cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); List <IssueDetail> issueDetails = new List <IssueDetail>(); while (dr.Read()) { IssueDetail obj = new IssueDetail(); obj.MantisID = (long)dr["MantisId"]; obj.SLNO = Convert.ToByte(dr["Slno"]); obj.Summary = dr["Summary"].ToString(); obj.AssingedBy = dr["AssingedBy"].ToString(); obj.ReportDate = Convert.ToDateTime(dr["ReportDate"]); obj.Description = dr["Description"].ToString(); obj.Priority = dr["Priority"].ToString(); obj.AssingedToList = GetAssingedToListById(obj.MantisID, obj.SLNO); //obj.AssingedToLists = GetAssingedToList(obj.MantisId, obj.Slno); //Get the list of AssingedToList issueDetails.Add(obj); } dr.Close(); con.Close(); return(issueDetails); }
public IssueDetail CreateNewStep(long?MantisId) { //string dbcs = "Data source=.;database=MantisDB;Integrated Security = SSPI"; InitializeConnectionString(); SqlConnection con = new SqlConnection(dbcs); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from IssueDetail where MantisId = " + MantisId + " and Slno = (select max(slno) from IssueDetail where mantisid = " + MantisId + " )"; cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); IssueDetail obj = new IssueDetail(); while (dr.Read()) { obj.MantisID = (long)dr["MantisId"]; obj.SLNO = Convert.ToByte(dr["Slno"]); obj.Summary = dr["Summary"].ToString(); obj.AssingedBy = dr["AssingedBy"].ToString(); obj.ReportDate = Convert.ToDateTime(dr["ReportDate"]); obj.Description = dr["Description"].ToString(); obj.Priority = dr["Priority"].ToString(); obj.AssingedToList = GetAssingedToListById(obj.MantisID, obj.SLNO); } dr.Close(); con.Close(); return(obj); }
public IEnumerable <IssueDetail> GetMasterIssueDetails() { //string dbcs = "Data source=.;database=MantisDB;Integrated Security = SSPI"; InitializeConnectionString(); SqlConnection con = new SqlConnection(dbcs); SqlCommand cmd = new SqlCommand(); //cmd.CommandText = "select * from IssueDetail where SLNo = 1 order by MantisId desc"; //cmd.CommandText = "select a.*, m.StartDate, m.CurrentStatus, StatusDate from IssueDetail a, IssueDetailMaster m where a.MantisId = m.MantisId and a.SLNo = 1 order by a.MantisId desc"; cmd.CommandText = "select a.MantisId, a.SLNo, m.IssueTitle Summary, a.AssingedBy, a.ReportDate,a.Description ," + " m.Priority,m.TypeOfWork, m.TaskComplexity, m.StartDate, m.CurrentStatus, StatusDate , Isnull(e.Estimate,'-1') Estimated " + " from IssueDetail a inner join IssueDetailMaster m on a.MantisId = m.MantisId " + " left join (select * from Estimate where slno=1) e on m.MantisId = e.MantisId" + " where a.SLNo = 1 order by a.MantisId desc"; cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); List <IssueDetail> issueDetails = new List <IssueDetail>(); while (dr.Read()) { IssueDetail obj = new IssueDetail(); obj.MantisID = (long)dr["MantisId"]; obj.SLNO = Convert.ToByte(dr["Slno"]); obj.Summary = dr["Summary"].ToString(); obj.AssingedBy = dr["AssingedBy"].ToString(); obj.ReportDate = Convert.ToDateTime(dr["ReportDate"]); obj.Description = dr["Description"].ToString(); obj.Priority = dr["Priority"].ToString(); obj.TypeOfWork = dr["TypeOfWork"].ToString(); //obj.TaskStatus = dr["TaskStatus"].ToString(); //obj.TaskSubStatus = dr["TaskSubStatus"].ToString(); obj.TaskComplexity = dr["TaskComplexity"].ToString(); obj.StartDate = (DateTime)dr["StartDate"]; obj.CurrentStatus = dr["CurrentStatus"].ToString(); obj.StatusDate = (DateTime)dr["StatusDate"]; obj.Estimated = dr["Estimated"].ToString(); obj.AssingedToList = GetAssingedToListById(obj.MantisID, obj.SLNO); //obj.AssingedToLists = GetAssingedToList(obj.MantisId, obj.Slno); //Get the list of AssingedToList issueDetails.Add(obj); } dr.Close(); con.Close(); return(issueDetails); }