public void insertPortSetting(BOLPortsetting portsettingBO, string sql)
{
using (con = DBaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter parcenterid, partid, parportname, parbaudrate, parmtype, parcompanyid;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = con;
parcenterid = cmd.Parameters.Add("@Centre_ID", SqlDbType.NVarChar, 50);
partid = cmd.Parameters.Add("@Table_ID", SqlDbType.Int);
parportname = cmd.Parameters.Add("@Port_Name", SqlDbType.NVarChar, 50);
parbaudrate = cmd.Parameters.Add("@Baud_Rate", SqlDbType.NVarChar, 50);
parmtype = cmd.Parameters.Add("@M_Type", SqlDbType.NVarChar, 50);
parcompanyid = cmd.Parameters.Add("@company_ID", SqlDbType.NVarChar, 50);
parcenterid.Value = portsettingBO.CentreID;
partid.Value = portsettingBO.TableID;
parportname.Value = portsettingBO.PortName;
parbaudrate.Value = portsettingBO.BaudRate;
parmtype.Value = portsettingBO.MType;
parcompanyid.Value = portsettingBO.Companyid;
cmd.ExecuteNonQuery();
}
}
public void EditUpdatePort(BOLPortsetting portBOL)
{
sqlstr = "Edit_Port";
portDA.EditUpdatePort(portBOL, sqlstr);
}
public void insertport(BOLPortsetting portBO)
{
string sql = "Insert_Port";
portDA.insertPortSetting(portBO, sql);
}
