public List <BranchParameter> GetBranchParameter(string branchCode)
{
int branchCode1 = int.Parse(branchCode);
BranchParameter bp = new BranchParameter();
return(bp.GetBranchParameterList(branchCode1));
}
private String BuildUpdateCommandBranchParameter(BranchParameter b)
{
String command;
StringBuilder sb = new StringBuilder();
string prefix = "UPDATE SM_ParametersBrnach Set ParameterWeight='" + b.ParameterWeight + "' WHERE BranchCode='" + b.BranchCode + "'" + "AND ParameterCode = '" + b.ParameterCode + "'";
command = prefix + sb.ToString();
return(command);
}
private String BuildInsertCommandBranchParameter(BranchParameter bp)
{
String command;
StringBuilder sb = new StringBuilder();
// use a string builder to create the dynamic string
sb.AppendFormat("Values('{0}' , '{1}' , '{2}')", bp.BranchCode.ToString(), bp.ParameterCode.ToString(), bp.ParameterWeight.ToString());
String prefix = "INSERT INTO SM_ParametersBrnach" + "(BranchCode , ParameterCode , ParameterWeight) ";
command = prefix + sb.ToString();
return(command);
}
public List <BranchParameter> GetBranchParameterList(int BranchCode)
{
List <BranchParameter> ParametersBranchList = new List <BranchParameter>();
SqlConnection con = null;
try
{
con = connect("DB7"); // create a connection to the database using the connection String defined in the web config file
String selectSTR = "SELECT * FROM SM_ParametersBrnach WHERE BranchCode='" + BranchCode + "'";
SqlCommand cmd = new SqlCommand(selectSTR, con);
// get a reader
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // CommandBehavior.CloseConnection: the connection will be closed after reading has reached the end
while (dr.Read())
{ // Read till the end of the data into a row
BranchParameter a = new BranchParameter();
a.BranchCode = Convert.ToInt32(dr["BranchCode"]);
a.ParameterCode = Convert.ToInt32(dr["ParameterCode"]);
a.ParameterWeight = (float)Convert.ToDouble(dr["ParameterWeight"]);
ParametersBranchList.Add(a);
}
}
catch (Exception ex)
{
// write to log
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
return(ParametersBranchList);
}
public int InsertBranchParameter(BranchParameter Bparameter)
{
SqlConnection con;
SqlCommand cmd;
try
{
con = connect("DB7"); // create the connection
}
catch (Exception ex)
{
// write to log
throw (ex);
}
String cStr = BuildInsertCommandBranchParameter(Bparameter); // helper method to build the insert string
cmd = CreateCommand(cStr, con); // create the command
try
{
int numEffected = cmd.ExecuteNonQuery(); // execute the command
return(numEffected);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
// close the db connection
con.Close();
}
}
}
// PUT: api/BranchParameter/5
public int Put([FromBody] BranchParameter [] b)
{
BranchParameter parameter = new BranchParameter();
return(parameter.UpdateBranchParameter(b));
}
// POST: api/BranchParameter
//public int PostBranchParameter([FromBody] BranchParameter [] p)
//{
// foreach (BranchParameter item in p)
// {
// float numOfParameters = item.ParameterWeight;
// item.ParameterWeight = 100 / numOfParameters;
// }
// return p.InsertBranchParameter();
//}
public int PostBranchParameter([FromBody] BranchParameter[] p)
{
BranchParameter t = new BranchParameter();
return(t.InsertBranchParameter(p));
}
// POST: api/BranchParameter
public int PostBranchParameter([FromBody] BranchParameter p)
{
return(p.InsertBranchParameter());
}
