} //========== end of the mtd
public VolumeAnalysisRundateRundateModel GetVolumeAnalysisRundateById(int Id)
{
VolumeAnalysisRundateRundateModel ddbObj = new VolumeAnalysisRundateRundateModel();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("", con);
//cmd.CommandText = "select * from Names where Id=@Id";
//cmd.Parameters.AddWithValue("@Id", id);
con.Open();
cmd.CommandText = "select * from volume_analysis_rundate where Id = @ID";
cmd.Parameters.AddWithValue("@ID", Id);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
//var obu = new VolumeAnalysisRundateRundateModel();
ddbObj.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
ddbObj.RunDate = reader["rundate"] != DBNull.Value ? DateTime.Parse(reader["rundate"].ToString()) : DateTime.Parse("1000-01-01");
ddbObj.visible = reader["visible"] != DBNull.Value ? reader["visible"].ToString() : "";
}
con.Close();
}
return(ddbObj);
} //========== end of the mtd
public IEnumerable <VolumeAnalysisRundateRundateModel> GetAllAnalysisRundate()
{
//param = param.Replace("FORWARDSLASHXTER", "/");
//param = param.Replace("DOTXTER", ".");
List <VolumeAnalysisRundateRundateModel> ddbList = new List <VolumeAnalysisRundateRundateModel>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("", con);
//cmd.CommandText = "select * from Names where Id=@Id";
//cmd.Parameters.AddWithValue("@Id", id);
con.Open();
cmd.CommandText = "select * from volume_analysis_rundate";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var obu = new VolumeAnalysisRundateRundateModel();
obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
obu.RunDate = reader["rundate"] != DBNull.Value ? DateTime.Parse(reader["rundate"].ToString()) : DateTime.Parse("1000-01-01");
obu.visible = reader["visible"] != DBNull.Value ? reader["visible"].ToString() : "";
ddbList.Add(obu);
}
con.Close();
}
return(ddbList);
} //========== end of the mtd
public HttpResponseMessage TeamStructureRegion(HttpRequestMessage request, int Id)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
VolumeAnalysisRundateMtd volObj = new VolumeAnalysisRundateMtd();
VolumeAnalysisRundateRundateModel volObj2 = new VolumeAnalysisRundateRundateModel();
volObj2 = volObj.GetVolumeAnalysisRundateById(Id);
response = request.CreateResponse <VolumeAnalysisRundateRundateModel>(HttpStatusCode.OK, volObj2);
return response;
}));
}
} //========== end of the mtd
public void UpdateVolumeAnalysisRundate(VolumeAnalysisRundateRundateModel updatev)
{
//param = param.Replace("FORWARDSLASHXTER", "/");
//param = param.Replace("DOTXTER", ".");
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
using (var cmd = new System.Data.SqlClient.SqlCommand("", con))
{
var query = "update volume_analysis_rundate set visible=@VISIBLE where Id = @ID";
con.Open();
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@VISIBLE", updatev.visible);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public HttpResponseMessage GetAccountTransferPrice(HttpRequestMessage request, [FromBody] VolumeAnalysisRundateRundateModel volmodel)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
VolumeAnalysisRundateMtd volObj = new VolumeAnalysisRundateMtd();
volObj.UpdateVolumeAnalysisRundate(volmodel);
return request.CreateResponse(HttpStatusCode.OK, response);
}));
}
