public HttpResponseMessage GetDetailsTop1(HttpRequestMessage request, string teamcode, int yr)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage res = null;
TeamStructureModel tb = new TeamStructureModel();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("getdetailstop1", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
//cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "TeamCode",
Value = teamcode,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Year",
Value = yr,
});
con.Open();
//cmd.ExecuteNonQuery();
//cmd2.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tb.TeamName = reader["TeamName"] != DBNull.Value ? reader["TeamName"].ToString() : "default";
tb.Branch_Code = reader["Branch_Code"] != DBNull.Value ? reader["Branch_Code"].ToString() : "default";
tb.BranchName = reader["BranchName"] != DBNull.Value ? reader["BranchName"].ToString() : "default";
tb.Region_Code = reader["Region_Code"] != DBNull.Value ? reader["Region_Code"].ToString() : "default";
tb.RegionName = reader["RegionName"] != DBNull.Value ? reader["RegionName"].ToString() : "default";
tb.Zone_Code = reader["Zone_Code"] != DBNull.Value ? reader["Zone_Code"].ToString() : "default";
tb.ZoneName = reader["ZoneName"] != DBNull.Value ? reader["ZoneName"].ToString() : "default";
tb.DIRECTORATECODE = reader["DIRECTORATECODE"] != DBNull.Value ? reader["DIRECTORATECODE"].ToString() : "default";
tb.DIRECTORATENAME = reader["DIRECTORATENAME"] != DBNull.Value ? reader["DIRECTORATENAME"].ToString() : "default";
}
con.Close();
}
//comm = "Operation Successful.";
res = request.CreateResponse(HttpStatusCode.OK, tb);
return res;
}));
}
public HttpResponseMessage UpdateDetailsTop1(HttpRequestMessage request, [FromBody] TeamStructureModel teamstructureModel)
{
return(GetHttpResponse(request, () =>
{
var comm = "";
HttpResponseMessage res = null;
//var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("updatedetailstop1", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
//cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Accountofficer_Code",
Value = teamstructureModel.Accountofficer_Code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "AccountofficerName",
Value = teamstructureModel.AccountofficerName,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Team_Code",
Value = teamstructureModel.Team_Code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "staff_id",
Value = teamstructureModel.staff_id,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Year",
Value = teamstructureModel.Year,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "TeamName",
Value = teamstructureModel.TeamName,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Branch_Code",
Value = teamstructureModel.Branch_Code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "BranchName",
Value = teamstructureModel.BranchName,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Region_Code",
Value = teamstructureModel.Region_Code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "RegionName",
Value = teamstructureModel.RegionName,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "DIRECTORATECODE",
Value = teamstructureModel.DIRECTORATECODE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "DIRECTORATENAME",
Value = teamstructureModel.DIRECTORATENAME,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Zone_Code",
Value = teamstructureModel.Zone_Code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "ZoneName",
Value = teamstructureModel.ZoneName,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Period",
Value = teamstructureModel.Period,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Team_StructureId",
Value = teamstructureModel.Team_StructureId,
});
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
comm = "Operation Successful.";
res = request.CreateResponse(HttpStatusCode.OK, comm);
return res;
}));
}
