public void UpdateVolumeAnalysisRundates(VolumeAnalysisRundatesModel vrd) { using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); con.Open(); cmd.CommandText = "Update volume_analysis_rundates set visible = @VISIBLE where Id=@ID"; cmd.Parameters.AddWithValue("@ID", vrd.Id); cmd.Parameters.AddWithValue("@VISIBLE", vrd.visible); cmd.ExecuteNonQuery(); con.Close(); } }
public void InsertVolumeAnalysisRundates(VolumeAnalysisRundatesModel vrd) { using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); con.Open(); cmd.CommandText = "Insert into volume_analysis_rundates (rundate, visible) values(@RUNDATE, @VISIBLE)"; cmd.Parameters.AddWithValue("@RUNDATE", vrd.rundate); cmd.Parameters.AddWithValue("@VISIBLE", vrd.visible); cmd.ExecuteNonQuery(); con.Close(); } }
public HttpResponseMessage GetVolumeAnalysisRundates(HttpRequestMessage request, int Id) { return(GetHttpResponse(request, () => { HttpResponseMessage response = null; //VolumeAnalysisRundates vrd = _MPRBSService.GetVolumeAnalysisRundates(Id); //response = request.CreateResponse<VolumeAnalysisRundates>(HttpStatusCode.OK, vrd); VolumeAnalysisRundatesModel vrd = new VolumeAnalysisRundatesModel(); VolumeAnalysisRundatesMtd ob = new VolumeAnalysisRundatesMtd(); vrd = ob.GetVolumeAnalysisRundates(Id); response = request.CreateResponse <VolumeAnalysisRundatesModel>(HttpStatusCode.OK, vrd); return response; })); }
// string linksev = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["linkserver"].Trim()); //string linksev = @"[127.0.0.1\dell].fintrak.dbo.volume_analysis_rundates"; public List <VolumeAnalysisRundatesModel> GetAllVolumeAnalysisRundates() { List <VolumeAnalysisRundatesModel> obuList = new List <VolumeAnalysisRundatesModel>(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); //string ls = linksev + ".volume_analysis_rundates"; con.Open(); //cmd.CommandText = "SELECT * from [10.1.14.49\fintrack].fintrakreport.dbo.volume_analysis_rundates"; //cmd.CommandText = " SELECT * from @LINKSERVER "; //var sqlString = string.Format("insert into {0} (time, date, pin) values (@time, @date, @pin)", linksev); //var sqlString = string.Format("SELECT * from {0} ", linksev); //cmd.CommandText = sqlString; // cmd.Parameters.AddWithValue("@LINKSERVER", linksev + ".dbo.volume_analysis_rundates"); cmd.CommandText = "SELECT * from volume_analysis_rundates"; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var ob = new VolumeAnalysisRundatesModel(); ob.Id = reader["Id"] != DBNull.Value ? Int32.Parse(reader["Id"].ToString()) : 0; ob.rundate = reader["rundate"] != DBNull.Value ? Convert.ToDateTime(reader["rundate"].ToString()).Date : Convert.ToDateTime("2001-01-01").Date; ob.visible = reader["visible"] != DBNull.Value ? Convert.ToString(reader["visible"]) : ""; obuList.Add(ob); } con.Close(); } return(obuList); }
public VolumeAnalysisRundatesModel GetVolumeAnalysisRundates(int Id) { VolumeAnalysisRundatesModel ob = new VolumeAnalysisRundatesModel(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); con.Open(); cmd.CommandText = "SELECT * from volume_analysis_rundates where Id=@ID"; cmd.Parameters.AddWithValue("@ID", Id); //cmd.Parameters.AddWithValue("@TAKETOP", taketop); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ob.Id = reader["Id"] != DBNull.Value ? Int32.Parse(reader["Id"].ToString()) : 0; ob.rundate = reader["rundate"] != DBNull.Value ? Convert.ToDateTime(reader["rundate"].ToString()).Date : Convert.ToDateTime("2001-01-01").Date; ob.visible = reader["visible"] != DBNull.Value ? Convert.ToString(reader["visible"]) : ""; } con.Close(); } return(ob); }
//public HttpResponseMessage UpdateVolumeAnalysisRundates(HttpRequestMessage request, [FromBody]VolumeAnalysisRundates vrdModel) public HttpResponseMessage InsertVolumeAnalysisRundates(HttpRequestMessage request, [FromBody] VolumeAnalysisRundatesModel vrdModel) { return(GetHttpResponse(request, () => { //var vrd = _MPRBSService.UpdateVolumeAnalysisRundates(vrdModel); //return request.CreateResponse<VolumeAnalysisRundates>(HttpStatusCode.OK, vrd); VolumeAnalysisRundatesMtd ob = new VolumeAnalysisRundatesMtd(); if (vrdModel.Id == 0) { ob.InsertVolumeAnalysisRundates(vrdModel); } else { ob.UpdateVolumeAnalysisRundates(vrdModel); } return request.CreateResponse(HttpStatusCode.OK); })); }