public DataTable getEngineerDetails(frmEngineerModel model) { try { DbCommand dbcommand = database.GetStoredPocCommand("SP_GetEngineerDetails"); database.AddInParameter(dbcommand, "@EngineerID", DbType.Int32, model.EngineerId); dt = database.ExecuteDataTable(dbcommand); return(dt); } catch (Exception) { throw; } }
public int InsertEngineerDetails(frmEngineerModel model) { try { DbCommand dbcommand = database.GetStoredPocCommand("SP_InsertEngineerDetails"); database.AddInParameter(dbcommand, "@EngineerID", DbType.String, model.EngineerId); database.AddInParameter(dbcommand, "@EngineerName", DbType.String, model.EngineerName); result = database.ExecuteNonQuery(dbcommand); return(result); } catch (Exception) { throw; } }